Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The topic is hydrocarbon emissions of automobiles and state what you are going to do/ write in the project report based on the Qs asked

The topic is hydrocarbon emissions of automobiles and state what you are going to do/ write in the project report based on the Qs asked

image text in transcribed
Excel Project 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 Canvas, 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

Students also viewed these Mathematics questions