Statistics HW - Only Experts Please - 4-5 Hours at the Max

ENGINEERING PROBABILITY & STATISTICS

3 Credit Hours, Fall 2018

Descriptive Statistics and Plots Project OBJECTIVES By the end of this project, you should be able to

1. Utilize descriptive statistics and plots on data using Excel 2. Perform exploratory analysis on an unknown dataset using descriptive statistics

and plots to derive conclusions on dataset. Deliverables The deliverables should be submitted on Blackboard by Wednesday, December 12th, 2018.

 A Word Document with the analysis of the data set which includes the following: o Descriptive Statistics and plots of data o Interpretations and conclusions for all statistics and plots o Overall conclusions

INTRODUCTION Engineers use statistical software to assist in the laborious and extensive calculations. The statistical packages can easily create a wide variety of graphs to display your data. This laboratory exercise is designed to enhance your skills and develop your ability to explore an unknown dataset and present your statistical results using Excel. Procedure You will perform analysis on a census dataset called state.x77 which is located on blackboard.

1. Create a histogram using one of the continuous data columns of the worksheet. a. Choose a suitable number of bins to represent the variation in the data. The

plot should be formatted and labeled appropriately. b. Provide interpretations for the plot.

2. Calculate the following descriptive statistics for the population data for each of the regions.

a. Mean, Median, and Mode b. Variance, Standard Deviation, and Range

3. Create a BoxPlot to compare population data for the different regions in the United States.

a. The plot should be formatted and labeled appropriately. b. Provide interpretations for the plot.

4. Compare and contrast the different regions. Be sure to discuss the variation for each region.

state.x77: a dataset (matrix) with 50 rows and 8 columns giving the following statistics in the respective columns. State: list of states in alphabetical order Population: population estimate as of July 1, 1975 Region: regional location of state Income: per capita income (1974) Illiteracy: illiteracy (1970, percent of population) Life Exp: life expectancy in years (1969–71) Murder: murder and non-negligent manslaughter rate per 100,000 population (1976) HS Grad: percent high-school graduates (1970) Frost: mean days with minimum temperature below freezing (1931–60) in capital or large city Area: land area in square miles A Subset of the Census data

State Region Population Income Illiteracy Life Exp Murder HS Grad Frost Area

Alabama South 3615 3624 2.1 69.05 15.1 41.3 20 50708

Alaska West 365 6315 1.5 69.31 11.3 66.7 152 566432

Arizona West 2212 4530 1.8 70.55 7.8 58.1 15 113417

Arkansas South 2110 3378 1.9 70.66 10.1 39.9 65 51945

California West 21198 5114 1.1 71.71 10.3 62.6 20 156361

Colorado West 2541 4884 0.7 72.06 6.8 63.9 166 103766

Connecticut East 3100 5348 1.1 72.48 3.1 56 139 4862