Purchase Solution

How to interpret regression analyses of population on sales

Not what you're looking for?

Ask Custom Question

A bank has offices in six different markets. It is feasible to say the annual sales of offices are related to the population of the communities they are in. The dependent variable, y, is annual sales. The independent variable, x is market population.

A regression analysis was conducted using Excel and the results of this analysis are provided.

1) Based on this output, what can you conclude?
2) Interpret all results, write the regression equation, and state whether this analysis was fit or not in predicting sales from market population?
3) What does that mean for business?

Answer each question briefly

Purchase this Solution

Solution Summary

Given a regression of sales and population data I provide an analysis of the output. I discuss the R^2 value and the overall goodness of fit for the model. I discuss various possible functional forms for the equation given a scatter plot of the variables. Given the regression results I interpret the coefficients and their significance (t-stats) and how they relate to the theory that as population increases so too do sales. I discuss the implications for the bank operating in the markets studied.

Solution Preview

Your adjusted R^2 is .83 which suggests the equation fits the data points reasonably well. Your F-stat of 25.81 also suggests a good fit. In eyeballing the scatterplot it almost appears as though a 3rd degree polynomial would fit the data best. So, you may want to tinker with that idea in excel. Just add the trend line and choose 3rd degree polynomial and check the box for display equation and R^2.

Now for the specific questions

(1) Based on this output, what can you conclude? You could certainly conclude that there is a ...

Purchase this Solution


Free BrainMass Quizzes
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.

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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

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