{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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

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

View Full Document
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*

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

View Full Document
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

{[ snackBarMessage ]}