{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Comparison of the Average Number of Hours of

# Comparison of the Average Number of Hours of - By Fatima...

This preview shows pages 1–5. Sign up to view the full content.

By Fatima Elzin

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
The Data Isurveyed 50 Freshmen and 50 Seniors at St. John’s University and asked them to give us a rough estimate of the number of hours of sleep they received on school nights We will compare the data using a scatter plot on excel Then we will find the mean number of hours from both groups and create a trend line
How to Calculate the Results Using excel we will create two graphs in the same manner, one for Freshmen and one for Seniors Label the first column as the “Number of Hours” and the second column as the “Number of Students” Enter the collected data Highlight the data, then select insert, then scatter plot After the graph is created, right click on one of the points on the graph and select “Format Trendline” Select the “Trend/Regression Type”, in this case we selected linear and then click on the option “Display Equation on Chart”, this is the slope

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Continued… We have now formed the graph and the found the slope of the data, this is what it should look like:
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 10

Comparison of the Average Number of Hours of - By Fatima...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online