SALES REPRESENTATIVE| NUMBER OF UNITS SOLD| NUMBER OF SALES CALLS| A| 28| 14|
B| 66| 35|
C| 38| 22|
D| 70| 29|
E| 22| 6|
F| 27| 15|
G| 28| 17|
H| 47| 20|
I| 14| 12|
J| 68| 29|
| | |
| | |

a) draw a scatter diagram of number of sales calls and number of units sold

b) Estimate a simple linear regression model to explain the relationship between number of sales calls and number of units sold y=2.139x-1.760
Number of units sold=2.139Number of units sold-1.760
c) Calculate and interpret the coefficient of correlation r=0.853=0.9236 (There is strong correlation between two variables as its near 1) d) the coefficient of determination
r2=0.853(The magnitude of the coefficient of determination indicates the proportion of variance in one variable, explained from knowledge of the second variable) e) the standard error of estimate

S.E=0.3133(The standard error is the estimated standard deviation of a statistic) f) Conduct a test of hypothesis to determine whether the coefficient of correlation in the population is zero H0:β1=0

Ha:β1≠0

t=β1SE =6.826
p-value for df=9 and t=6.826:0.001

0.0001<0.05
Therefore null hypothesis is rejected
Hence coefficient of correlation is zero is rejected
Therefore there is significant relationship between number of sales calls and number of units sold. g) Construct and interpret confidence intervals and prediction intervals for the dependent variable, number of units sold. Confidence interval:

(x-tsn,x+tsn)
Confidence interval for number of sales calls:

(x-tsn,x+tsn)
(0.924, 2.8612)

CALCULATIONS ON EXCEL

Regression Analysis| | | | | | |
| | | | | | | |
| r² | 0.853 | n | 10 | | | |
| r | 0.924 | k | 1 | | | |
| Std. Error | 8.412 | Dep. Var. | NUMBER OF UNITS SOLD| | | | | | | | | |
ANOVA table| | | | | | | |
Source| SS | df | MS| F| p-value...

...Quantitative Methods Project
RegressionAnalysis for the pricing of players in the
Indian Premier League
Executive Summary
The selling price of players at IPL auction is affected by more than one factor. Most of these factors affect each other and still others impact the selling price only indirectly. The challenge of performing a multiple...

...STA9708
RegressionAnalysis: Literacy rates and Poverty rates
As we are aware, poverty rate serve as an indicator for a number of causes in the world. Poverty rates are linked with infant mortality, education, child labor and crime etc. In this project, I will apply the regressionanalysis learned in the Statistics course to study the relationship between literacy rates and poverty rates among different states in USA. In my study, the...

...REGRESSIONANALYSIS (SIMPLE LINEAR REGRESSION)
Submitted By
Maqsood Khan
MS - MANAGEMENT SCIENCES, 2nd SEMESTER
Submitted TO
GOHAR REHMAN
ASSISTANT: PROFESSOR, SUIT
Sarhad University
Of Science And Information Technology
Peshawar
SESSION: 2012-13
TABLE OF CONTENTS
|S. No. |Subjects |Page No. |
|1...

...CHAPTER 16
SIMPLE LINEAR REGRESSION
AND CORRELATION
SECTIONS 1 - 2
MULTIPLE CHOICE QUESTIONS
In the following multiple-choice questions, please circle the correct answer.
1. The regression line [pic] = 3 + 2x has been fitted to the data points (4, 8), (2, 5), and (1, 2). The sum of the squared residuals will be:
a. 7
b. 15
c. 8
d. 22
ANSWER: d
2. If an estimated regression line has a y-intercept of 10...

...Project 1: Linear Correlation and RegressionAnalysis
Gross Revenue and TV advertising:
Pfizer Inc, along with other pharmaceutical companies, has begun investing more promotion dollars into television advertising. Data collected over a two year period, shows the amount of money Pfizer spent on television advertising and the revenue generated, all on a monthly bases.
|Month |TV advertising |Gross Revenue |
|1 |17...

...Question 1:
Run the regression Report your answer in the format of equation 5.8 (Chapter 5, p. 152) in the textbook including and the standard error of the regression (SER). Interpret the estimated slope parameter for LOT. In the interpretation, please note that PRICE is measured in thousands of dollars and LOT is measured in acres.
Model 1: OLS estimates using the 832 observations 1-832
Dependent variable: price
VARIABLE COEFFICIENT...

...Name: GAO FAN
Student Number: 139030647
Programme Title: Analysis of the Efficient Market Hypothesis
Module Title: FOUNDATIONS OF FINANCIAL ANALYSIS AND INVESTMENT (MN7022)
Assignment Question: Critically review and discuss the concept of market efficiency and empirical approaches to test for it.
Words number: 2994
Analysis of the Efficient Market Hypothesis
INTRODUCTION
The study of “efficient...

...Introduction to Linear Regression and Correlation Analysis
Goals
After this, you should be able to:
• • • • •
Calculate and interpret the simple correlation between two variables
Determine whether the correlation is significant Calculate and interpret the simple linear regression equation for a set of data Understand the assumptions behind regressionanalysis Determine whether a regression model is...

## Share this Document

Let your classmates know about this document and more at StudyMode.com