Mathematics
Excel Project (short)-Probability and Statistics

Question Description

1- Write a short introduction to the topic.

2- Use Excel to do your calculation.

3- Answer the questions.

4- Write a short conclusion


No plagiarism

Unformatted Attachment Preview

Excel Project 12345- Write a short introduction to the topic. Use Excel to do your calculation. Answer the questions. Write a short conclusion. Submit your work on the link provided on Blackboard, pasted on a word document and a pdf document. Both required. The hydrocarbon emissions at idling speed in parts per million (ppm) for automobiles of 1980 and 1990 model years are given for 20 randomly selected cars. 1980 models: 141 359 247 940 882 494 306 210 105 880 200 223 188 940 241 190 300 435 241 380 1990 models: 140 160 20 20 223 60 20 95 360 70 220 400 217 58 235 380 200 175 85 65 • (a) Compute the sample means for the two years and superimpose the two means on the plots. Compute sample standard deviation for the two years • (b) Construct a relative frequency histogram of the 1980 data. • (c) Construct a stem-and-leaf display of the 1990 data. • (d) Construct a dot plot. • (e) Comment on what the dot plot indicates regarding whether or not the population emissions changed from 1980 to 1990. Use the concept of variability in your comments. ...
Purchase answer to see full attachment

Final Answer

Hi there!Attached please find the completed assign...

Selenica (1623)
University of Virginia

Anonymous
Return customer, been using sp for a good two years now.

Anonymous
Thanks as always for the good work!

Anonymous
Excellent job

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors