Covariance - Movie Ticket (X-XBar)(Y-YBar) 5.99 32.66...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Covariance Analysis Movie Ticket (X-XBar)(Y-YBar) 5.99 32.66 12.67491 7.62 28.41 21.88597 5.75 20 -0.09483 4.45 20.71 -0.31052 4.99 18 -0.02335 5.29 19.5 -0.19375 4.39 18 1.25045 3.7 16 5.27332 4.62 18.05 0.74421 2.99 9.9 20.33355 Calculations XBar 4.98 YBar 20.12 9 Sum 61.53993 Covariance 6.83777 Hamburger Meal n -1 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.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Covariance Analysis
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Movie Ticket (X-XBar)(Y-YBar) 5.99 32.66 =(A4-$C$16)*(B4-$C$17) 7.62 28.41 =(A5-$C$16)*(B5-$C$17) 5.75 20 =(A6-$C$16)*(B6-$C$17) 4.45 20.71 =(A7-$C$16)*(B7-$C$17) 4.99 18 =(A8-$C$16)*(B8-$C$17) 5.29 19.5 =(A9-$C$16)*(B9-$C$17) 4.39 18 =(A10-$C$16)*(B10-$C$17) 3.7 16 59.20000 4.62 18.05 =(A12-$C$16)*(B12-$C$17) 2.99 9.9 =(A13-$C$16)*(B13-$C$17) Calculations XBar =AVERAGE(A4:A13) YBar =AVERAGE(B4:B13) =COUNT(A4:A13)-1 Sum =SUM(C4:C13) Covariance =C19/C18 Hamburger Meal n-1...
View Full Document

This note was uploaded on 02/27/2010 for the course ECON 210 taught by Professor Dk during the Spring '09 term at Bridgewater State University.

Page1 / 2

Covariance - Movie Ticket (X-XBar)(Y-YBar) 5.99 32.66...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online