Answered step by step
Verified Expert Solution
Link Copied!

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)? 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Trade

Authors: John McLaren

1st edition

0470408790, 978-0470408797

More Books

Students also viewed these Economics questions

Question

A greater tendency to create winwin situations.

Answered: 1 week ago

Question

Improving creative problem-solving ability.

Answered: 1 week ago