EXCEL PROBABILITY AND STATS PROJECT

Order Instructions/Description

 

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