Correlation - Hamburger Meal(X-XBar 2(Y-YBar 2 n-1 S X S Y...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Movie Ticket (X-XBar)(Y-YBar) 5.99 32.66 1.0221 157.1764 12.6749 7.62 28.41 6.9749 68.6744 21.8860 5.75 20 0.5944 0.0151 -0.0948 4.45 20.71 0.2798 0.3446 -0.3105 4.99 18 0.0001 4.5071 -0.0234 5.29 19.5 0.0967 0.3881 -0.1938 4.39 18 0.3469 4.5071 1.2504 3.7 16 1.6358 16.9991 5.2733 4.62 18.05 0.1289 4.2973 0.7442 2.99 9.9 3.9561 104.5097 20.3335 Sums: 15.04 361.42 61.5399 : Calculations XBar 4.98 YBar 20.12 9 Covariance 6.83777 1.2925 6.3370 r 0.8348
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Hamburger Meal (X-XBar) 2 (Y-YBar) 2 n-1 S X S Y When modifying this sheet for other data sets, adjust the table area by first selecting row 5 and then inserting or deleting rows as is necessary. Changing the table in this manner will allow Excel to automatically update the formulas in the Calculations section....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online