Data Analysis -

Minor Project 1: Data Analysis and Descriptive statistics

1. A National homebuilder builds single-family homes and condominium townhouses. The Excel file House Sales provides information on the selling price, low cost, type of home, and region of the country (M=Midwest, S=South) for closings during one month. Use PivotTables to find the average selling price and lot cost for each type of home in each region of the market.

a. What conclusions might you reach from this information? (See House Sales Excel spreadsheet)

·

·

·

·

2. The Excel file MBA Student Survey provides data on sample of student’s social and study habits. Use PivotTables to find average age, number of nights out per week, and average study hours per week by gender, whether the student is international or not, and undergraduate concentration. (See Evans, p. 57, # 33). Present all appropriate tables for results.

a. What conclusion might be reached from this information? (See MBA Student Survey Excel spreadsheet)

·

·

·

·

3. The Excel file Cell Phone Survey reports opinions of a sample of consumers regarding the signal strength, value for the dollar, and customer service for their cell phone carriers. Use PivotTables to find the following and present all tables of results: The average signal strength by type of carrier. Average value for the dollar by type of carrier and usage level. Variance of perception of customer service by carrier and gender.

a. What conclusions might you reach from this information? (See Cell Phone Survey Excel spreadsheet)

·

·

·

·

4. Using the National Football League data file, perform Descriptive Statistics and Correlation Test, using the Data Analysis tool or PHSTAT for all variables found in columns B-N. Present the tables.

a. Discuss what conclusions must be reached from the results. (See National Football League Excel spreadsheet)

·

·

·

·