EXCEL PROBABILITY AND STATS PROJECT

Assignment Requirements

Math 120 Excel Project

 

Your Excel project will be made up of 10 smaller projects. You will complete these throughout the semester and turn in all 10 at one time. Your instructor will give you a date that these should be turned in. You will submit your project through the drop box feature of D2L. Please submit your project as one file rather than 10 individual files.

 

In order to receive maximum credit, your project should have nothing handwritten, all graphs should have a title, and axes should be labeled. You should use the Excel functions noted in your text, not find the values by hand or with your calculator then enter them. The project must be turned in on time. Points will be deducted for not meeting format and deadlines.

 

Before you begin work, go to pages 28 and 29 in your text for directions for adding the Analysis Tool Pack. DO NOT LOAD MEGASTAT!

 

Please refer to pages 54, 70, 94, 127, and 147 in the ninth edition of Elementary Statistics by Bluman for instructions to complete the following Excel projects. You may also find Google and Youtube to be valuable resources.

 

Categorical Frequency Table for problem #14 on page 52

 

Grouped Frequency Table for Data Set XI on page 808

 

Histogram for Data Set XI on page 808

 

Ogive for Data Set XI on page 808

 

Frequency Polygon for Data Set XI on page 808

 

Pie Chart for problem #23 on page 92

 

Pareto for problem #16 on page 102

 

Time Series for problem #18 on page 102

 

Measures of Central Tendency for Data Set II on page 806

 

Measures of Variation for Data Set II on page 806

 

Order Now

YOU CAN ALSO PLACE OTHER SIMILAR ORDERS ON OUR WEBSITE AND GET AMAZING DISCOUNTS!!!