Question
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)? 6. Who is more stressed: male or female? Junior vs. senior? How do results on stress compare with the results on life satisfaction? 7. What is the relationship between life satisfaction and number of hours worked? Include a count of people in different work categories in a separate column. 8. What is the relationship between life satisfaction and income level? Include a count of people in different income categories in a separate column. a. Make sure to order the categories in a logical order (Excel will order them for you alphabetically) 9. What is the relationship between self-sufficiency and life satisfaction? 10. What is the relationship between social media use and life satisfaction? Which group is most/least happy? What do you make of these results? 11. What is the relationship between Social life and life satisfaction? Compare this to results obtained in the previous question - what do you notice? What conclusion can you make?
| Timestamp | Overall Life Satisfaction | Stress | Year of study | Gender | Employment: | Household income | Self-sufficient | Debt | Economic Conditions | Social Media | Friends and Social life | |
| 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 to Expert-Tailored 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
International Trade
Authors: John McLaren
1st edition
0470408790, 978-0470408797
