E270 Spring 2023 Computer Exercise List of Excel Commands/Actions Please complete the

E270

Spring 2023

Computer Exercise

List of Excel Commands/Actions

Please complete the following commands in Excel.

You will need to turn in the results (output) of these commands along with a narrative that describes the results and gives reasoning as to why you used this/these variable(s) in your analysis.

Each command below will be worth 8 points ( 6 points for proper execution of the command and 2 points for each narrative). HINT: Don’t forget to title your charts and label your axes!

Chapter 3/4: Calculate descriptive statistics for the quantitative variable or variables of your choice (max, min, mean, median, range, standard deviation, skewness).

Chapter 2: Prepare a frequency distribution and a histogram for the quantitative variable or variables of your choice.

Chapter 2: Prepare a bar chart for the qualitative variables of your choice (Or bedrooms/bathrooms).

Chapter 2: Construct pie charts for number of bedrooms and bathrooms qualitative variables of your choice (Or bedrooms/bathrooms).

Chapter 4: Construct a box plot for quantitative variable or variables of your choice. You can use the built in chart feature on new versions of Excel or do this one is by hand, but you should show your results to get the relevant data points (max, min, Q1, Q3, and median) if you do it by hand.

Chapter 6: Construct a contingency table to evaluate the relationship between two qualitative variables (you may want to present these as probabilities instead of counts)

Construct 95% confidence intervals for home sales price (or another quantitative variable) in each township.

Chapter 4: Construct at least one scatter diagram to evaluate the relationship between quantitative variables.

Chapter 13/14: Use regression analysis to evaluate the impact that several independent variables (# of bedrooms, # of bathrooms, size of home, and distance from downtown) have on the sales price for a home.

Chapter 13/14: Include dummy variables for pool and garage in your regression analysis conducted in #9.