statistics project

MATH 1342 - Summer 2020

Project Instructions and Rubric Due: Saturday, August 1 at 11:30 PM

This project is designed to be completed individually or in teams of two class members. If you choose to have a partner, this should be clearly stated in the memo. Each partner should submit his/her own identical assignment. Each team member will receive the same grade on this assignment.

You will write a report in memo format (sample provided) which summarizes your answers to questions about the provided data. Grammar and spelling are important. The project will be completed in three parts. Parts 1 and 2 will be graded for completion. Your instructors will provide early feedback, if requested. Part 3 is the final submission of the memo and will be graded using the rubric on the following page.

For the final project, you must upload the memo - containing all three parts - and the Excel workbook.

Part 1: Summary Statistics

Use Excel to do the following with the provided data set: The data provided present information about home prices in certain subdivisions, also providing information about the number of bedrooms, bathrooms, and square footage of the house. Choose a subdivision to study and then choose whether you will examine it by number of bedrooms, number of bathrooms, acreage, or square footage. For this first part, focus only on the subdivision and the price of the house. Be able to report on the following:

1. What is the mean price of the houses in the subdivision you are studying? 2. Give the 5-number summary of the price of the houses in the subdivision you are studying 3. Generate an appropriate graphical representation of your data. 4. Are there any outliers of your data? Be sure to use the statistical definition and justify. 5. Type up a paragraph (or more) discussing the results of your analysis, including any conclusions you can make.

Part 2: Bivariate Analysis

1. Is there a linear relationship between two sets in the data you are considering (this is the price of the house and whichever other variable you choose to study (number of bedrooms, number of bathrooms, acreage, or square footage)? Use the statistical concepts discussed in class to determine correlation. For example: - Is there a strong correlation between the price of the house and the number of bedrooms in the subdivision

you are studying? - Is there a correlation between the price of the house and the number of bathrooms? - Is there a correlation between the price of the house and the acreage? - Is there a correlation between the price of the house and the square footage?

2. Provide an appropriate graphical representation of your data. 3. Type up a paragraph (or more) discussing the results of your analysis, including any conclusions you can make.

Part 3: Memo

Time to put it all together. Build the remainder of the memo. The paragraphs created from Parts 1 and 2 of the project will comprise the body of the memo. You must now type your Introduction and Conclusion. Please reference the sample memo. Note: You may need to edit your pre-written paragraphs to smooth the flow and transition between paragraphs.

0 pts 5 pts 10 pts Pts

Part 1 No work provided Incomplete assignment

submitted Complete Assignment Submitted

Part 2 No work provided Incomplete assignment

submitted Complete Assignment Submitted

Part 3 0 pts 5 pts 10 pts 15 pts 20 pts Pts

Summary Statistics

No summary statistics provided

Only measures of

center provided

Only measures of center and spread

provided

Measures of center, spread and

graphical information

provided

Measures of center, spread, graphical

information provided, and

outliers provided

Bivariate data

No bivariate data analysis

provided

Scatterplot provided

Scatterplot and linear relationship

provided

Scatterplot, linear relationship and

correlation coefficient provided

Scatterplot, linear relationship, correlation

coefficient and conclusion provided

Memo No written

report submitted

Written report in wrong format or

incomplete

Memo supplied, but few details

provided

Memo supplied, with appropriate

level of detail, but contains grammar or spelling errors

Well-written memo supplied with few

errors

Written analysis and conclusions

No written analysis

Analysis presents some

of the requested statistics

Analysis presents all of the requested

statistics, but no conclusions drawn

Analysis presents all requested

statistics and draws 2 or fewer

conclusions

Analysis presents all requested statistics

and draws more than 2 conclusions