Purchase Solution

ANOVA Table and Regression Model of Sales per Person

Not what you're looking for?

Ask Custom Question

Please see the attached file for better table format.

) Fill in the missing values in following ANOVA table

Source df SS MS F
Factor 346.2 115.4 20.79
Error 16
Total

Answer
a. In the above ANOVA table, is the factor significant at 5% level of significant?

4) A regression model relating x, number of sales persons at a branch office, to y, annual sales at the office ($1000s), has been developed. The computer output from a regression analysis of the data follows.

The regression equation is

Y = 80.0 + 50.0X

Predictor Coef Stdev t-ratio
Constant 80.0 11.333 7.06
X 50.0 5.482 9.12
Analysis of Variance
SOURCE DF SS MS
Regression 1 6828.6 6828.6
Error 28 2298.8 82.1
Total 29 9127.4

a. Write the estimated regression equation
b. How many branch offices were involved in the study?
c. Compute the F statistic and test the significance of the relationship at a .05 level of significance.
d. Predict the annual sales at the Memphis branch office. This branch has 12 sales persons.

Attachments
Purchase this Solution
Solution Summary

This solution fills in missing values in the ANOVA table and determines the estimated regression equation, finds branch office number, computes the f-statistic and predicts the annual sales at the Memphis branch office.

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

View More Free Quizzes
Related BrainMass Solutions

  • Interpret sales tables and give CEO advice

    The regression model is significant, with an F statistic of 4.27 and p<0.001 and so can be used. The F statistics is a measure of the significance of the model in predicting DV (sales).

  • Chi square goodness of fit test, ANOVA

    After running a regression to determine a predictive model for sales (monthly revenue in thousands) based on average number of hours spent per day making sales calls by your sales staff, you come up with the following regression output: SUMMARY OUTPUT

  • Regression Analysis: Bikes

    354384 Applied Statistics for Mountain Bikes: Regression model, ANOVA table, t statistic Need the three attached problems completed.

  • Regression analysis

    21 10,000.00 a) Complete the ANOVA table.

  • Simple Linear Regression: Price of steak per pound to total sales of steak in a week

    Because the p-value for the regression model (which is in the ANOVA table) is less than 0.05, we reject the null hypothesis and conclude that the age of the customers can predict the number of orders placed in a year.

  • Regression and Time Series Analysis

    e) Predict the sales per store for a day in which the temperature is 83F. f) determine the coefficient of determination and interpret its meaning.

  • Simple Regression: Sales Prices of Houses by Size

    Attempt to answer this question by estimating a simple regression model where the sales price of the house is the dependent variable and the size of the house is the independent variable. Use the sample data. Interpret your estimated model.

  • Regression Statistics and ANOVA

    224278 Regression Statistics and ANOVA Effectively interpret and explain this output to your immediate supervisor. Be complete, through and technically correct but do not quote or use textbook definitions per se.

  • Multiple Regression Analysis, Time Series Analysis

    Oh, and he also asks you to do a time-series analysis on the total sales per quarter and forecast the amount of sales expected in the future. Part I. Multiple Regression: 1. Look over the expenditure categories that the CEO gave you.

View More Related Solutions