Question

In: Statistics and Probability

Use excel only, please! problem #1 data contains data on automobile manufacturer who employs sales representatives...

Use excel only, please!

problem #1 data contains data on automobile manufacturer who employs sales representatives who make calls on dealers. The manufacturer wishes to compare the effectiveness of four different call-frequency plans for the sales representatives. Thirty-two representatives are chosen at random from the sales force and randomly assigned to the four call plans for six months, and their sales for the 6-month study period are recorded. Do the sample data support the hypothesis that at least one of the calls plans helps produce a higher average level of sales? Perform an appropriate statistical test and report a P-value.

Plan A Plan B Plan C Plan D
36 39 44 31
40 45 43 43
32 54 38 46
44 53 40 43
35 46 41 36
41 42 35 49
44 35 37 46
42 39 37 48

Solutions

Expert Solution

Anova in excel

1. Arrange the data in excel as shown below.

2. Select one factor anova from the data analysis tab.

3. Input the value as shown.

4. The output will be generated as follows.

Hypothesis.

Ho: The average sales for all the 4 plans is equal
H1: The average sales for all the 4 plans is not equal

From the ANOVA output we look at the pvalue which is 0.1944(highlighted in yellow). Since the pvalue is greater than 0.05, we fail to reject the null hypothesis and conclude that the mean average sales for all the 4 plans is equal

Hence we conclude that the differnt calls plans are not helping to produce higher average level of sales.


Related Solutions

THIS PROBLEM NEEDS TO BE SOLVED ONLY USING EXCEL SOFTWARE! 1. Use the following data set...
THIS PROBLEM NEEDS TO BE SOLVED ONLY USING EXCEL SOFTWARE! 1. Use the following data set to answer the following: ew dbh e 23.5 e 43.5 e 6.6 e 11.5 e 17.2 e 38.7 e 2.3 e 31.5 e 10.5 e 23.7 e 13.8 e 5.2 e 31.5 e 22.1 e 6.7 e 2.6 e 6.3 e 51.1 e 5.4 e 9 e 43 e 8.7 e 22.8 e 2.9 e 22.3 e 43.8 e 48.1 e 46.5 e 39.8...
(PLEASE READ ) :) Use the data below to solve the following problem using excel: (...
(PLEASE READ ) :) Use the data below to solve the following problem using excel: ( I would like to know how do you input the formula for each category, so please explain the process) I will RATE and comment your answer accordingly 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in...
Use the data below to solve the following problem using excel: 1 a) Import the data...
Use the data below to solve the following problem using excel: 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in each cell to determine the class for each vehicle. i. Class 1 if the vehicle horsepower is less than 80 HP. ii. Class 2 if the vehicle horsepower is between 81 and...
***Excel is required to solve this problem. Please use excel and show all formulas used in...
***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...
In the Excel data file, the tab labeled Question 1 contains data on the number of...
In the Excel data file, the tab labeled Question 1 contains data on the number of times boys and girls raise their hands in class. Conduct the t-test: Two-Sample Assuming Equal Variances. Males 9,8,4,9,3,8,10,8,9,10,7,6,12 Females 3,5,1,2,6,4,3,6,7,9,7,3,7,6,8,8 a. What is the null hypothesis? b. What is the research hypothesis? c. Why run a Two-Sample Assuming Equal Variances t-test? d. Interpret the findings. What are the results of the hypothesis test? Can you reject the null hypothesis?
Use the data and Excel to answer this question. It contains the United States Census Bureau’s...
Use the data and Excel to answer this question. It contains the United States Census Bureau’s estimates for World Population from 1950 to 2014. You will find a column of dates and a column of data on the World Population for these years. Generate the time variable t. Then run a regression with the Population data as a dependent variable and time as the dependent variable. Have Excel report the residuals. (a) Based on the ANOVA table and t-statistics, does...
Use the data and Excel to answer this question. It contains the United States Census Bureau’s...
Use the data and Excel to answer this question. It contains the United States Census Bureau’s estimates for World Population from 1950 to 2014. You will find a column of dates and a column of data on the World Population for these years. Generate the time variable t. Then run a regression with the Population data as a dependent variable and time as the dependent variable. Have Excel report the residuals. (a) Based on the ANOVA table and t-statistics, does...
USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for...
USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for the problem in the first worksheet named LightbulbLife of the data table down below It gives the data on the lifetime in hours of a sample of 50 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. Identify the null and the alternate hypotheses for...
Please use ONLY one Excel file to complete this case study, and use one spreadsheet for...
Please use ONLY one Excel file to complete this case study, and use one spreadsheet for each problem. Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable. Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable. Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable. Which of these three models is the best?  Use R-square values, Significance...
c# only please Objectives Use the more advanced data structures introduced to accomplish a difficult problem....
c# only please Objectives Use the more advanced data structures introduced to accomplish a difficult problem. Tasks This assignment has two parts: Read from a file. Write to a file. Task 1 – File Input The first piece of information we need is a text file’s name and location. Ask the user through the console what the file’s name and location are. After that, please ensure that the file does exist and at the given location. If the file does...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT