Statictics class

User Generated

nynmzv906

Mathematics

Description

Excel Project to be submit through the hyperlink under this item.

Due

1-Write a short introduction to the topic.

2-Use Excel to do your calculation.

3-Answer the questions.

4-Write a short conclusion.

5-Submit your work on the link provided on Blackboard, pasted on a word document and a pdf document. Both required.

Unformatted Attachment Preview

Excel Project Due 2/16 1- Write a short introduction to the topic. 2- Use Excel to do your calculation. 3- Answer the questions. 4- Write a short conclusion. 5- 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. rī n
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags