# What is the correlation between height and shoe size? How would you classify the relationship (e.g., no relationship to weak, weak, moderate, strong, very strong)

###### Solve the following two equations in two unknowns:
September 12, 2020
###### What specific legal liability regarding manufactured products developed
September 12, 2020

Utilizing the Homework4.xls file attached at the bottom, answer and perform the following questions and summarizations.

Within the excel file, you do not need to use a different worksheet for each question. However, label the questions and make your answers aesthetically pleasing and easy to follow. Failure to follow this request will result in a 10% grade penalty.

1. The Weather worksheet includes monthly average temperature and rainfall in a Midwest town. Create a combination chart (of temperature and rainfall) involving a column and line graph including a secondary axis.

1. The Survey worksheet contains results evaluating a college course. Create a PivotTable of the averages of each question. Include a second column of that table that gives the standard deviation for each question. Your table should look something like this:

 Average of Response Standard Dev Easy to Follow xxx xxx Exams were fair and relevant xxx xxx I want to learn more in this area xxx xxx xxx xxx xxx etc.

1. Using the Height/Shoe worksheet:
2. What is the average shoe size?
3. What is the average height?
4. What is the standard deviation of height?
5. 95% of the heights are approximately from _______ to _________.
6. Insert a scatter plot chart of the data between height and shoe size. Format each axis to make the chart look nice.
7. What is the correlation between height and shoe size? How would you classify the relationship (e.g., no relationship to weak, weak, moderate, strong, very strong)

1. The HouseData worksheet gives the square footage and sales prices for several houses in a neighborhood. Using this worksheet, answer the following questions:
2. Create a scatter plot depicting the data. Display the trend line equation onto the chart. Display the R2 value onto the chart.
3. You currently have a 2,225 square foot home. Using the trend line equation, what is the estimated sales price for the home?
4. You plan on building a 500 square foot addition to your 2,225 square foot home, what is the estimated value increase of the addition? What is the new estimated value of your home?
5. What percentage of the variation in home value is explained by the variation in the house size?

1. The OfficeSupplies worksheet contains daily sales volume (in dollars) of laser printers, printer cartridges, and office supplies.
2. Find and interpret the correlations (e.g., no relationship to weak, weak, moderate, strong, very strong) between each set of quantities (between printers and cartridges, between cartridges and office supplies, and between printers and office supplies).

PLACE THIS ORDER OR A SIMILAR ORDER WITH MY ONLINE PROFESSOR TODAY AND GET AN AMAZING DISCOUNT

The post What is the correlation between height and shoe size? How would you classify the relationship (e.g., no relationship to weak, weak, moderate, strong, very strong) appeared first on MY ONLINE PROFESSOR .