What is the average shoe size from the given table

Assignment Help Marketing Research

Reference no: EM131274046

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.

2. 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.

3. Using the Height/Shoe worksheet:

1. What is the average shoe size?
2. What is the average height?
3. What is the standard deviation of height?
4. 95% of the heights are approximately from _______ to _________.
5. Insert a scatter plot chart of the data between height and shoe size. Format each axis to make the chart look nice.
6. 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)

4. The HouseData worksheet gives the square footage and sales prices for several houses in a neighborhood. Using this worksheet, answer the following questions:
a. Create a scatter plot depicting the data. Display the trend line equation onto the chart. Display the R2 value onto the chart.

b. You currently have a 2,225 square foot home. Using the trend line equation, what is the estimated sales price for the home?

c. 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?

d. What percentage of the variation in home value is explained by the variation in the house size?

5. The OfficeSupplies worksheet contains daily sales volume (in dollars) of laser printers, printer cartridges, and office supplies.

a. 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).

*** Within the excel file, label each request (1a, 1b, 3a, 3b, etc.) as a separate worksheet within the excel file. Make sure to answer the questions asked within the sheets and not just do the tables and charts. Before jumping right into the questions, it is recommended that you look at the data and the fields first to understand what the information is and its importance.**

Attachment:- hw4.xlsx

Reference no: EM131274046

Questions Cloud

What legal or regulatory constraints have contributed : What was the organizational structure under which the actions took place? What legal or regulatory constraints have contributed to the behavior witnessed or have been violated in the course of the behavior?

Create a presentation based on conflict management : Create a PowerPoint presentation based on your final research paper topic (Conflict Management). The presentation should have an introduction slide, as well as a reference slide(s) at the end of the presentation.

Identify sources available to understand scope of project : Identify sources available to understand the scope of the project proposal. Describe the phases the project will contain. Develop the project scope for your project.

What is the average shoe size from the given table : 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?What percentage of the variation in home value is explained by the va..

Initial basis of each of emelio and charitas assets : Based on the information provided, determine the initial basis of each of Emelio and Charita's assets. If more than one basis is possible, list the alternatives and explain when each basis would apply.

Prepare a memo proposal using the aida model : Create a memo proposal using the AIDA model in a Microsoft Word in a minimum of 1,400 words. You will add an introduction and conclusion, and your paper will include the following components.

What is the highest possible payment on the arm : What is the highest possible payment on the ARM (Loan D) when the interest rate adjusts at the end of 5 years? Loan C - This option for the Homebuyers is to put down 10%.

Strategic plan calls for an aggressive growth plan : The organization's strategic plan calls for an aggressive growth plan, requiring investment in facilities and equipment, growth in productivity, and labor over the next five years. It is your team's task to determine where, outside the United Stat..

User Account

All Pages