upstat101chap3 - 273.5 =QUARTILE($B$6:$B$21,3) Count 16...

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

View Full Document Right Arrow Icon
Rates 425 440 450 465 480 510 575 430 440 450 470 485 515 575 430 440 450 470 490 525 580 435 445 450 472 490 525 590 435 445 450 475 490 525 600 435 445 460 475 500 535 600 435 445 460 475 500 549 600 435 445 460 480 500 550 600 440 450 465 480 500 570 615 440 450 465 480 510 570 615
Background image of page 1

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

View Full DocumentRight Arrow Icon
Obtaining Summary Statistics using Microsoft Excel Consider the cost, in US cents for a standard size bar of 16 different milk chocolate brands: Cost in Milk Chocolate Cents/bar To obtain summary statistics, Godiva 500 Cote d'Or 399 Moonstruck 300 La Nouba Sugar Free 299 corresponding function. Droste 265 See's 250 Suchard Milka 249 Ross 245 Lindt (blue label) 219 Lindt (red label) 200 Ghirardelli 199 Toblerone 195 Perugina Latte 189 Cadbury Dairy 149 Hershey's 65 Nestle 60 SUMMARY STATISTICS Function Mean 236.4375 =AVERAGE($B$6:$B$21) Median 232 =MEDIAN($B$6:$B$21) Mode #VALUE! =MODE($B$6:$B$21) Minimum 60 =MIN($B$6:$B$21) Maximum 500 =MAX($B$6:$B$21) Range 440 =$B$28-$B$27 Variance 12016.2625 =VAR($B$6:$B$21) Standard Deviation 109.6187142 =STDEV($B$6:$B$21) Skewness 0.6739056535 =SKEW($B$6:$B$21) First Quartile Q1* 193.5 =QUARTILE($B$6:$B$21,1) Third Quartile Q3*
Background image of page 2
Background image of page 3

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

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

Unformatted text preview: 273.5 =QUARTILE($B$6:$B$21,3) Count 16 =COUNT($B$6:$B$21) * Note: The values for the quartiles may vary from the answers provided using PHSTAT. use the Function Wizard key f x , then select the category Statistical , then select the Group A Group B Group C 40 40 40 40 50 50 50 60 60 50 70 60 50 80 60 50 80 70 50 80 70 50 90 70 60 90 70 60 90 70 60 90 80 70 90 80 80 90 80 90 100 90 100 100 100 Rates Class Intervals Frequency Class Marks x * f 425 420 - 439 8 440 440 - 459 17 450 460 - 479 12 465 480 - 499 8 480 500 - 519 7 510 520 - 539 4 575 540 - 559 2 430 560 - 579 4 440 580 - 599 2 450 600 - 619 6 470 TOTAL 70 485 515 575 430 440 450 470 490 525 580 435 445 450 472 490 525 590 435 445 450 475 490 525 600 435 445 460 475 500 535 600 435 445 460 475 500 549 600 435 445 460 480 500 550 600 440 450 465 480 500 570 615 440 450 465 480 510 570 615 2 ( ) x x f-...
View Full Document

This note was uploaded on 11/26/2011 for the course STATISTICS 101 taught by Professor Dean during the Spring '09 term at University of the Philippines Diliman.

Page1 / 4

upstat101chap3 - 273.5 =QUARTILE($B$6:$B$21,3) Count 16...

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

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