Question

In: Statistics and Probability

Objective of this Assignment: To conduct a regression and correlation analysis Instructions: The term paper involves...

Objective of this Assignment: To conduct a regression and correlation analysis Instructions: The term paper involves conducting a regression and correlation analysis on any topic of your choosing. The paper must be based on yearly data for any economic or business variable, for a period of at least 20 years (Note: the source of the data must be given. Data which is not properly documented as to source is unacceptable and paper will be graded F. Textbook examples are unacceptable). The paper can be between 3 to 5 pages (1500 to 2000 words). The term paper should distinguish between dependent and independent variables; determine the regression equation by the least squares method; plot the regression line on a scatter diagram; interpret the meaning of regression coefficients; use the regression equation to predict values of the dependent variable for selected values of the independent variable and construct forecast intervals and calculate the standard error of estimate, coefficients of determination (r2) and correlation (r) and interpret the meaning of the coefficients (r2) and (r). Your regression and correlation analysis must: 1. Graph the data (scatter diagram) 2. Use the method of least squares to derive a trend equation and trend values
 3. Use check column to verify computations ∑ (Y-Yc)=0
 4. Superimpose trend equation on scatter diagram.
 5. Use your model to predict the movement of the variable for the next year.
 6. Compare your predictions with the actual behavior of the variable during the 21styear .

Solutions

Expert Solution

SOLUTION

Solution:

Suppose you have N pairs of data points (X_1, Y_1), (X_2, Y_2), ... (X_N, Y_N) and you would like to know the relationship of the Y's to the X's and, if possible, predict one from the other. The X's and Y's could be whatever you like, but let's say for now that they are heights and weights. You would expect there to be a clear relationship between the two; on average, you would expect taller people to be heavier than shorter people.

A good way to start might be to model the relationship with a linear equation, Y = mX + b, where m is the slope of the line and b is the Y-intercept, as you learned in high school algebra. The question now is to determine the best way to estimate m and be given your pairs of X's and Y's.

It turns out that the best way to do this is to use least squares regression. We call it least squares regression because the line that we choose will be the one for which the sum of the squares of the differences between predicted and observed values is as small as possible.

1. Scatter Plot of Y and X1

Scatter plot of sales and calls shows that there can be a linear trend between the both. The trendline indicates that it looks like higher the number of calls, higher will be sales

2. Best fit line

Using the Regression option in Excel Data analysis menu, we obtaain the following output

From this, bestfit line equation is Sales=Intercept+Coefficient of Calls *Calls

i.e., Sales = 22.52 + 0.1237 * Calls

3. Coefficient of Correlation

It denotes the strength of association between two variables. The sign denotes the direction of association.

In Exel, we calculate Correlation coefficient as Correl(X1array,Yarray)

We get the value as 0.318

This means that calls and sales are slightly positively associated. With increase in one quantiity, the other is also showing an increasing trend. Please note that this does not imply causation, i.e.,we CANNOT say that the rise or fall in one is causing the change in other.

4. Coefficient of Determination

It is more commonly known as R squared value. It gives the measure of how close the data points are to the best fit line. In other words, it gives the proportion of variability in dependent variable that can be explained by the independent variable. Higher the Rsquared value, better the model is.

From Excel regression output, we get R squared value or Coefficient of Determination as 0.101

~10% of variability in sales is explained by calls.

5. Utility of Regression model

F test can be used to test the utility of the model.

Null Hypothesis: Beta coefficient of call = 0; i.e., Calls is NOT linearly associated with sales

Alternate Hypothesis: Beta coefficient of call 0; Calls is linearly associated with sales

Let us choose significance level, = 0.05.

From the regression ANOVA output, we get p value (or significance value) of F test as 0.0012 (<0.05) for the given degrees of freedom (highlighted)

Since p value < , we can reject Null hypothesis, thereby concluding that with the given data it can be said that calls is linearly associated with sales.

6. Based on the above findings, it can be said that calls is a good and important variable in predicting sales volume. It has been proved that calls and sales have a positive linear association between them. From the best fit line (Sales = 22.52 + 0.1237 * Calls), we can say that with every call, sales increases by 0.1237units (interpretation of coefficient of calls).


Related Solutions

Objective of this Assignment:    To conduct a regression and correlation analysis Instructions: The term paper involves...
Objective of this Assignment:    To conduct a regression and correlation analysis Instructions: The term paper involves conducting a regression and correlation analysis on any topic of your choosing. The paper must be based on yearly data for any economic or business variable, for a period of at least 20 years (Note: the source of the data must be given. Data which is not properly documented as to source is unacceptable and paper will be graded F. Textbook examples are unacceptable)....
I have to submit a term paper which involves conducting a regression and correlation analysis on...
I have to submit a term paper which involves conducting a regression and correlation analysis on any topic of my choosing. The paper must be based on yearly data for any economic or business variable, for a period of at least 20 years. The following also must be included in the paper: • The term paper should distinguish between dependent and independent variables; determine the regression equation by the least squares method; plot the regression line on a scatter diagram;...
HW 9: Linear Regression and Correlation Analysis INSTRUCTIONS: Please modify the Excel sheet attached to complete...
HW 9: Linear Regression and Correlation Analysis INSTRUCTIONS: Please modify the Excel sheet attached to complete this assignment. Turn in the following work including: 1) written formulas, 2) values from Excel plugged into formulas, and 3) final answer. Scenario: A graduate student has administered a pro-inflammatory substance, lipopolysaccharide (LPS), to rats in the form of a pill (several doses – 0 mg or placebo, 1.25 mg, 2.5 mg, 5.0 mg, and 10 mg). She then determines the blood concentration of...
Intro Discussion and Questions- Regression and Correlation: How does correlation analysis differ from regression analysis? What...
Intro Discussion and Questions- Regression and Correlation: How does correlation analysis differ from regression analysis? What are the goals of each? What does the correlation coefficient r measure? Be specific. What values can it take on? What do the values indicate? What values can the coefficient of determination take on? What does it measure? What are some of the limitations of simple linear regression? Describe the equation for multiple linear regression; be sure to clearly define all of its parts....
How is a linear regression analysis is different from a correlation analysis?
How is a linear regression analysis is different from a correlation analysis?
The objective of this assignment is to gain an understanding of the lexical analysis phase of...
The objective of this assignment is to gain an understanding of the lexical analysis phase of a compiler and the process of constructing a symbol table. Problem: The first phase of compilation is called scanning or lexical analysis. This phase interprets the input program as a sequence of characters and produces a sequence of tokens, which will be used by the parser. Write a program (in C, C++, C#, Java, or Python) that implements a simple scanner for a source...
Instructions The major assignment for this course will be a student paper researching the molecular biology...
Instructions The major assignment for this course will be a student paper researching the molecular biology of cancer and exploring ethical considerations related to molecular testing. Cancer is often caused by the malfunction of the fundamental biological processes that are the subject of this course. Your paper should include the following: • Introduction • Discussion of the following molecular causes of cancer: o Somatic mutations o Epigenetic mutations • Explanation of the principal processes altered in cancer (i.e. cell division...
Using the following data, conduct a linear regression analysis (by hand). In this analysis, you are...
Using the following data, conduct a linear regression analysis (by hand). In this analysis, you are testing whether SAT scores are predictive of overall college GPA. Also, write out the regression equation. How would you interpret your results? SAT Score GPA 670 1.2 720 1.8 750 2.3 845 1.9 960 3.0 1,000 3.3 1,180 3.2 1,200 3.4 1,370 2.9 1,450 3.8 1,580 4.0 1,600 3.9
What is the real difference between between correlation and regression analysis? I see that correlation allows...
What is the real difference between between correlation and regression analysis? I see that correlation allows us to examine whether two variables exhibit some kind of association with each other. Does correlation mean means that one variable is dependent on another? Is this an example of correlation - Tips are dependent on the actual restaurant bill? Can you give other examples of correlation and regression? Thanks.
Conduct a regression and correlation hypothesis test step 1 to step 5 on the data below...
Conduct a regression and correlation hypothesis test step 1 to step 5 on the data below before you answer each question. The number of fat calories and number of saturated fate grams for a random selection of nonbreakfast entrees are shown below. Use a .05 level of significance. Y X 9 190 8 220 13 270 17 360 23 460 27 540 What is the null and alternative hypotheses step one? a. H0: There is no relationship. H1: There is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT