Study Guides (238,612)
York University (9,816)
Final

# Chapter 16 - Example.xlsx

6 Pages
117 Views

School
York University
Department
Course
Professor
Michael Rochon
Semester
Winter

Description
x y Given Value 10 2 7 4 11 6 17 Coffee Consumption VS Smoking 8 21 40 10 27 13 36 35 y = 2.6371x + 0.934 Process - Exel 2007 30 1. Click Data Tab 25 2. Click on Data Analysis 3. Click on Regression 20 4. Fill in fields 15 10 5 0 0 2 4 6 8 10 12 Coffee Consumption VS Smoking y = 2.6371x + 0.934 X and Y Linear (X and Y) 14 SUMMARY OUTPUT Regression Statistics Multiple R 0.997617114 R Square 0.995239906 Adjusted R Square 0.994049882 Standard Error 0.819856663 Observations 6 ANOVA df SS MS F Significance F Regression 1 562.1446735 562.1446735 836.3195297 8.51045E-06 Residual 4 2.688659794 0.672164948 Total 5 564.8333333 Coefficients Standard Error t Stat P-value Lower 95% Intercept 0.934
More Less

OR

Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Join to view

OR

By registering, I agree to the Terms and Privacy Policies
Just a few more details

So we can recommend you notes for your school.