Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. What is the average life satisfaction in your class? What is the median? (Use average & median functions in excel.) 2. What is the
1. What is the average life satisfaction in your class? What is the median? (Use average & median functions in excel.) 2. What is the correlation of life satisfaction and stress (use CORREL function in Excel)? Is this what you would expect? 3. MAKE a scatter plot of stress and life satisfaction. Is this in line with your correlation coefficient? For the next series of questions, we will be looking at average life satisfaction for different categories of people, so you will need to use PivotTable option (see instructions below). For each question report EITHER your table OR your bar graph (but for the whole homework you need to have at least one bar graph and at least one table). Copy them into the word file (paste as image to preserve formatting). brief description of what you observe AND what you think are some possible reasons for the patterns you observe. COMPARE your results to what we studied in class where applicable (i.e. gender, stress, income). Note that some of the categories will not be in the logical order. You will need to copy the table into another area of excel and rearrange the rows in the right order before you copy to your word file. 4. What is the average life satisfaction by gender? 5. What is the average life satisfaction by college year (junior vs. senior)?
| 2022/08/22 6:09:13 PM HADT | 7 | 3 | junior | Female | over 30 | Middle 20% | I only earn some pocket money | Yes | Fair | 4-6 hours | 3-5 hours |
| 2022/08/24 7:39:43 AM HADT | 7 | 3 | senior | Female | 0 (i.e. no paid employment) | Middle 20% | I earn enough to completely provide for myself | No | Fair | 2-3 hours | 3-5 hours |
| 2022/08/24 7:19:34 PM HADT | 5 | 5 | senior | Female | 20-29 | Second 20% | I earn enough to completely provide for myself | Yes | Poor | 7-10 hours | 1-3 hours |
| 2022/08/25 12:17:24 PM HADT | 10 | 1 | junior | Male | over 30 | Second 20% | I earn enough to completely provide for myself | Yes | Excellent | 4-6 hours | 1-3 hours |
| 2022/08/26 1:55:10 PM HADT | 6 | 3 | senior | Female | 0 (i.e. no paid employment) | Middle 20% | I only earn some pocket money | No | Good | over 10 hours | 6-10 hours |
| 2022/08/29 7:47:54 AM HADT | 6 | 4 | senior | Male | 0 (i.e. no paid employment) | Fourth 20% | I only earn some pocket money | No | Good | 4-6 hours | 1-3 hours |
| 2022/08/29 7:13:49 PM HADT | 8 | 3 | completed BA | Male | 0 (i.e. no paid employment) | Richest 20% | My parents completely provide for me | No | Good | 4-6 hours | 3-5 hours |
| 2022/08/29 11:05:59 PM HADT | 9 | 3 | completed BA | Male | over 30 | Richest 20% | I earn enough to completely provide for myself | Yes | Excellent | 2-3 hours | 6-10 hours |
| 2022/08/30 2:05:32 PM HADT | 7 | 2 | senior | Male | 20-29 | Second 20% | I only earn some pocket money | No | Poor | 2-3 hours | 6-10 hours |
| 2022/08/31 3:50:56 PM HADT | 5 | 4 | senior | Female | over 30 | Bottom 20% | I earn enough to completely provide for myself | No | Good | 7-10 hours | 6-10 hours |
| 2022/08/31 8:46:59 PM HADT | 5 | 3 | senior | Female | over 30 | Middle 20% | I provide for a substantial portion of my expenses | No | Good | 7-10 hours | 3-5 hours |
| 2022/08/31 10:48:55 PM HADT | 8 | 2 | senior | Male | 1 to 10 | Richest 20% | I provide for a substantial portion of my expenses | Yes | Good | 1 hour or less | 3-5 hours |
| 2022/09/01 3:56:01 PM HADT | 5 | 4 | junior | Male | over 30 | Richest 20% | I provide for a substantial portion of my expenses | No | Good | 2-3 hours | 6-10 hours |
| 2022/09/01 7:34:07 PM HADT | 7 | 2 | senior | Male | 10 to 19 | Fourth 20% | I only earn some pocket money | Yes | Good | 4-6 hours | 6-10 hours |
| 2022/09/02 6:53:22 AM HADT | 7 | 2 | senior | Male | 0 (i.e. no paid employment) | Middle 20% | My parents completely provide for me | No | Good | over 10 hours | 1-3 hours |
| 2022/09/02 9:22:07 AM HADT | 8 | 2 | senior | Female | 20-29 | Middle 20% | I provide for a substantial portion of my expenses | Yes | Excellent | 4-6 hours | over 10 hours |
| 2022/09/02 9:31:21 AM HADT | 8 | 3 | junior | Male | over 30 | Richest 20% | I only earn some pocket money | Yes | Fair | 7-10 hours | 6-10 hours |
| 2022/09/02 9:50:00 AM HADT | 8 | 4 | junior | Male | over 30 | Richest 20% | I only earn some pocket money | Yes | Fair | 7-10 hours | 6-10 hours |
| 2022/09/02 10:39:23 AM HADT | 7 | 2 | junior | Female | 10 to 19 | Middle 20% | I only earn some pocket money | No | Poor | 4-6 hours | 3-5 hours |
| 2022/09/02 10:42:07 AM HADT | 7 | 2 | senior | Male | 0 (i.e. no paid employment) | Second 20% | I earn enough to completely provide for myself | No | Fair | 4-6 hours | 1-3 hours |
| 2022/09/02 12:51:01 PM HADT | 7 | 4 | junior | Male | 0 (i.e. no paid employment) | Middle 20% | My parents completely provide for me | No | Fair | over 10 hours | 6-10 hours |
| 2022/09/02 1:30:37 PM HADT | 5 | 5 | senior | Male | 0 (i.e. no paid employment) | Second 20% | My parents completely provide for me | No | Good | 4-6 hours | over 10 hours |
| 2022/09/02 6:24:08 PM HADT | 3 | 5 | senior | Male | 0 (i.e. no paid employment) | Middle 20% | I provide for a substantial portion of my expenses | Yes | Fair | 2-3 hours | 3-5 hours |
| 2022/09/02 7:52:16 PM HADT | 7 | 5 | senior | Female | 20-29 | Second 20% | I earn enough to completely provide for myself | Yes | Good | 2-3 hours | less than 1 hour |
| 2022/09/02 7:53:00 PM HADT | 8 | 5 | senior | Female | over 30 | Second 20% | I earn enough to completely provide for myself | Yes | Good | 2-3 hours | less than 1 hour |
| 2022/09/02 8:31:08 PM HADT | 6 | 3 | senior | Female | over 30 | Middle 20% | I earn enough to completely provide for myself | Yes | Fair | 7-10 hours | less than 1 hour |
| 2022/09/02 10:19:44 PM HADT | 4 | 2 | senior | Female | 0 (i.e. no paid employment) | Bottom 20% | My parents completely provide for me | No | Fair | 1 hour or less | 3-5 hours |
| 2022/09/02 10:40:07 PM HADT | 4 | 4 | senior | Female | 10 to 19 | Middle 20% | I only earn some pocket money | No | Excellent | 7-10 hours | 3-5 hours |
| 2022/09/02 11:25:25 PM HADT | 6 | 3 | senior | Male | over 30 | Middle 20% | I provide for a substantial portion of my expenses | No | Good | 4-6 hours | 1-3 hours |
| 2022/09/03 12:00:43 AM HADT | 7 | 4 | junior | Male | over 30 | Middle 20% | I earn enough to completely provide for myself | Yes | Fair | 2-3 hours | 3-5 hours |
| 2022/09/03 12:40:05 AM HADT | 7 | 3 | senior | Male | 1 to 10 | Middle 20% | I only earn some pocket money | No | Fair | 7-10 hours | 3-5 hours |
| 2022/09/03 12:55:04 AM HADT | 6 | 4 | senior | Male | 10 to 19 | Middle 20% | I only earn some pocket money | Yes | Good | 1 hour or less | 6-10 hours |
| 2022/09/03 9:57:22 AM HADT | 8 | 4 | senior | Female | over 30 | Middle 20% | I earn enough to completely provide for myself | No | Good | 7-10 hours | 6-10 hours |
| 2022/09/03 10:56:22 AM HADT | 6 | 3 | senior | Female | 0 (i.e. no paid employment) | Middle 20% | I only earn some pocket money | No | Good | over 10 hours | 6-10 hours |
| 2022/09/03 11:55:44 AM HADT | 9 | 3 | senior | Female | 20-29 | Middle 20% | I earn enough to completely provide for myself | No | Good | 4-6 hours | over 10 hours |
| 2022/09/03 12:00:13 PM HADT | 7 | 4 | junior | Male | 10 to 19 | Bottom 20% | I earn enough to completely provide for myself | No | Poor | over 10 hours | over 10 hours |
| 2022/09/03 2:10:24 PM HADT | 4 | 3 | junior | Female | 1 to 10 | Middle 20% | I only earn some pocket money | Yes | Good | 7-10 hours | over 10 hours |
| 2022/09/03 3:22:41 PM HADT | 7 | 3 | senior | Male | 10 to 19 | Fourth 20% | I provide for a substantial portion of my expenses | Yes | Good | 7-10 hours | 6-10 hours |
| 2022/09/03 3:23:16 PM HADT | 8 | 3 | senior | Male | 10 to 19 | Fourth 20% | I provide for a substantial portion of my expenses | Yes | Good | 7-10 hours | 6-10 hours |
| 2022/09/03 3:24:14 PM HADT | 9 | 2 | senior | Male | 0 (i.e. no paid employment) | Middle 20% | I only earn some pocket money | No | Fair | over 10 hours | over 10 hours |
| 2022/09/03 3:25:13 PM HADT | 7 | 3 | senior | Male | over 30 | Bottom 20% | I provide for a substantial portion of my expenses | Yes | Fair | over 10 hours | over 10 hours |
| 2022/09/03 3:46:50 PM HADT | 9 | 4 | senior | Male | over 30 | Middle 20% | I earn enough to completely provide for myself | Yes | Good | over 10 hours | over 10 hours |
| 2022/09/03 3:47:32 PM HADT | 9 | 4 | senior | Male | over 30 | Middle 20% | I earn enough to completely provide for myself | Yes | Good | over 10 hours | over 10 hours |
| 2022/09/03 5:41:23 PM HADT | 7 | 4 | junior | Male | 10 to 19 | Middle 20% | I provide for a substantial portion of my expenses | Yes | Fair | 4-6 hours | 6-10 hours |
| 2022/09/03 5:49:37 PM HADT | 8 | 3 | junior | Male | 10 to 19 | Middle 20% | I only earn some pocket money | Yes | Good | 4-6 hours | 6-10 hours |
| 2022/09/03 8:37:31 PM HADT | 7 | 4 | senior | Female | 0 (i.e. no paid employment) | Bottom 20% | I only earn some pocket money | No | Good | over 10 hours | 6-10 hours |
| 2022/09/03 9:26:01 PM HADT | 10 | 1 | junior | Female | 0 (i.e. no paid employment) | Richest 20% | My parents completely provide for me | No | Excellent | 2-3 hours | over 10 hours |
| 2022/09/03 10:29:19 PM HADT | 7 | 2 | senior | Female | 0 (i.e. no paid employment) | Middle 20% | My parents completely provide for me | Yes | Poor | 7-10 hours | 3-5 hours |
| 2022/09/03 10:36:55 PM HADT | 5 | 2 | senior | Male | over 30 | Middle 20% | I provide for a substantial portion of my expenses | Yes | Good | 1 hour or less | less than 1 hour |
| 2022/09/03 11:01:59 PM HADT | 8 | 1 | senior | Male | over 30 | Middle 20% | I earn enough to completely provide for myself | Yes | Excellent | 7-10 hours | over 10 hours |
| 2022/09/03 11:10:44 PM HADT | 7 | 4 | senior | Male | over 30 | Fourth 20% | I earn enough to completely provide for myself | Yes | Fair | 4-6 hours | 1-3 hours |
| 2022/09/03 11:11:23 PM HADT | 4 | 4 | senior | Male | 20-29 | Bottom 20% | I earn enough to completely provide for myself | Yes | Fair | 2-3 hours | 1-3 hours |
| 2022/09/03 11:19:24 PM HADT | 8 | 2 | junior | Female | 1 to 10 | Middle 20% | I only earn some pocket money | No | Fair | 7-10 hours | 6-10 hours |
| 2022/09/03 11:56:57 PM HADT | 7 | 4 | senior | Male | over 30 | Second 20% | My parents completely provide for me | No | Good | 2-3 hours | 1-3 hours |
| 2022/09/04 12:00:50 AM HADT | 6 | 3 | senior | Male | over 30 | Bottom 20% | I provide for a substantial portion of my expenses | Yes | Fair | 4-6 hours | 3-5 hours |
| 2022/09/04 12:18:50 AM HADT | 6 | 4 | senior | Male | 20-29 | Bottom 20% | I only earn some pocket money | Yes | Poor | 7-10 hours | 6-10 hours |
| 2022/09/04 8:52:15 AM HADT | 9 | 2 | senior | Male | 20-29 | Middle 20% | I earn enough to completely provide for myself | Yes | Fair | over 10 hours | over 10 hours |
| 2022/09/04 8:53:19 AM HADT | 9 | 3 | junior | Female | 20-29 | Fourth 20% | I earn enough to completely provide for myself | No | Good | 4-6 hours | over 10 hours |
| 2022/09/04 2:06:11 PM HADT | 7 | 5 | senior | Female | over 30 | Middle 20% | I provide for a substantial portion of my expenses | Yes | Fair | 2-3 hours | 1-3 hours |
| 2022/09/04 4:10:42 PM HADT | 8 | 4 | senior | Male | over 30 | Fourth 20% | I provide for a substantial portion of my expenses | No | Good | 2-3 hours | 3-5 hours |
| 2022/09/05 11:02:07 PM HADT | 4 | 4 | junior | Male | 0 (i.e. no paid employment) | Middle 20% | My parents completely provide for me | No | Fair | over 10 hours | 3-5 hours |
| 2022/09/06 7:02:57 PM HADT | 7 | 3 | senior | Female | 0 (i.e. no paid employment) | Second 20% | I provide for a substantial portion of my expenses | Yes | Good | 4-6 hours | 1-3 hours |
| 2022/09/06 11:21:27 PM HADT | 6 | 5 | senior | Male | 10 to 19 | Middle 20% | I only earn some pocket money | No | Fair | 2-3 hours | over 10 hours |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Entrepreneurship
Authors: Andrew Zacharakis, William D Bygrave
5th Edition
1119563097, 9781119563099
