logo

APPLIED MANAGERIAL STATISTICS

Analyzing sales data to determine the most productive sales and applying training to fulfill the productive number of sales.

10 Pages1265 Words18 Views
   

Added on  2022-09-09

APPLIED MANAGERIAL STATISTICS

Analyzing sales data to determine the most productive sales and applying training to fulfill the productive number of sales.

   Added on 2022-09-09

ShareRelated Documents
Running head: APPLIED MANAGERIAL STATISTICS 1
Maths 534: Applied Managerial Statistics
Student Name
Professor’s Name
University Name
Date
APPLIED   MANAGERIAL   STATISTICS_1
APPLIED MANAGERIAL STATISTICS 2
Applied Managerial Statistics
Step 1
The scatter plot for sales (Y) against Calls (X) is shown below. The variable sales represent the
dependent variable hence placed on the vertical axis while calls represent the independent
variable and is place on the horizontal axis (Holmes, Illowsky & Dean, 2019)
The scatter plot indicates that there is a positive linear relationship between sales and calls.
Therefore, an increase in the number of calls made in a week would result to an increase in the
number of sales made during the week.
Step 2
The equation of the “best fit” line that explains the relationship between the independent and the
dependent variable is:
Y =0.1278 x +23.141
Where Y is the dependent variable (sales) and x is the independent variable (calls). In terms of
the variables the equation can be written as:
Sales ( Y ) =0.1278 Calls( X )+23.141
APPLIED   MANAGERIAL   STATISTICS_2
APPLIED MANAGERIAL STATISTICS 3
The coefficient of calls or the slope of the regression line shows that the independent variable
(calls) impact the dependent variable (sales) by a magnitude of 0.1278 while the intercept shows
the value of sales would be 23.141 given that no calls were made.
Step 3
The coefficient of correlation can be determined from the scatter plot as:
R= R2
R= 0.1095
R=0.3309
It can also be determined using the correlation matrix below.
Correlation matrix
Calls (X1) Sales (Y)
Calls (X1) 1
Sales (Y) 0.330919 1
The coefficient of correlation (0.3309) show that the amount of relationship between the
independent and dependent variable that can be explained by the data is equal to 33.09% (Bruce,
2015)
Step 4
The coefficient of determination is the R-squared value shown in the scatter plot. It is equivalent
to:
Rsquared=0.1095
The coefficient of determination (0.1095) shows that the amount of variability in the dependent
variable that can be explained by the independent variable is equivalent to 10.95% (Levie, 2012)
Step 5
We need to test the utility of the regression equation. The null and the alternative hypothesis can
mathematically be expressed as:
APPLIED   MANAGERIAL   STATISTICS_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
ECONOMETRIC QUESTION 3: Relationship between Total Consumption Expenditure and Level of Wealth
|16
|2449
|55

Regression and Correlation Analysis
|6
|1231
|456

Statistics for Business
|10
|733
|61

Statistics: CO2 Emission, Frequency Distribution, Regression Model
|9
|779
|270

Statics For Financial Decisions Report 2022
|16
|2640
|21

(PDF) Essentials of Business Research Methods
|6
|1035
|164