Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me create an excel data sheet with the following scenario: Dr . Truong wants to examine the relation between the amount of television

Please help me create an excel data sheet with the following scenario:
Dr. Truong wants to examine the relation between the amount of television that people watch and how happy they are. Ten adults participate in her study. Each participant records the total number of hours of TV that he or she watches for a particular week. In addition, at the end of the week, each participant completes a questionnaire that measures the person's overall happiness. The questionnaire scores can range from 0(extremely unhappy) to 10(extremely happy). The results from Dr. Truong's experiment are listed below.
\table[[Participant Number,Hours of TV Watched,Happiness Score],[1,8,4],[2,5,6],[3,3,9],[4,3,8],[5,0,10],[6,1,10],[7,6,5],[8,4,8],[9,5,5],[10,5,5]]
Directions for Data Set 1:
Enter the data from the table above into an Excel spreadsheet. Label row 1 of columns A,B, and C with "Participant Number," "Hours of TV Watched," and "Happiness Score," respectively.
In the "Participant Number column," in cells 14 through 18 respectively, type in the following terms: mean, median, mode, variance, and standard deviation.
Use Excel to compute the mean, median, mode, variance, and standard deviation (round to two decimal places). NOTE: Excel has a several ways of calculating the standard deviation & variance. Make sure that you have selected the correct ones by calculating the standard deviation of Hours of TV Watched.
Use Excel to create a scatterplot for these two variables. Label the X-axis "Hours of TV Watched" and the Y-axis "Happiness Score," and make sure that the data along each axis correspond to the correct variable (e.g., make sure that data plotted on an axis matches your label for it).
Enter your name as part of the X-axis label. To do this, create the basic table first. After you have positioned it in your spreadsheet, click on the label (once to select it) and insert your cursor after the last letter. Hit "Return" and then type your name.
Add a trendline to your chart. This will visually illustrate the line the correlation is attempting to fit to the data. To do this, select your chart by clicking on it once. The "Chart" menu will appear above at the top of the page, in between the "Tools" and "Window" menus. The Chart menu will not appear if you don't select your chart. You will see the "Table" menu instead and you won't be able to create a trendline. With your chart selected, click on (or pull down) the "Chart" menu and select "Add Trendline..." You want a linear trendline, which is usually the default setting. If "Linear" is already highlighted, click "OK" and a trendline line will be added to your chart.
image text in transcribed

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

Data Science For Dummies

Authors: Lillian Pierson ,Jake Porway

2nd Edition

1119327636, 978-1119327639

More Books

Students also viewed these Databases questions

Question

What questions should Jessica ask of Anna?

Answered: 1 week ago

Question

Choose an appropriate organizational pattern for your speech

Answered: 1 week ago

Question

Writing a Strong Conclusion

Answered: 1 week ago