Question

In: Statistics and Probability

A Sales Manager at WATWIUC Stores collected data on annual sales (in thousand Ghana Cedis) and...

A Sales Manager at WATWIUC Stores collected data on annual sales (in thousand Ghana Cedis)
and years of experience of 30 sales persons. He wants to explore the relationship between years
of experience and annual sales.
a) Which variable is the dependent variable in this study?
b) Which variable is the independent variable in this study?
c) The coefficient of correlation between the dependent variable and the independent
variable was found to be 0.9, meaning that the dependent and the independent variables
are strongly positively related. As CEO of the WATWIUC stores what would you
recommend with respect to the independent variable? Be specific.
d) What is the value of the coefficient of determination in this study?
e) Interpret in the context of this study the meaning of the value of the coefficient of determination you found in d)
f) The Sales Manager in his study developed an estimated regression equation that can be used to predict annual sales given the years of experience. The estimated regression
equation is Y= 18+2X where Y is the dependent variable and X is the independent variable. Explain to someone who is not familiar with statistics or mathematics the meaning of 18 (value of the intercept or constant) in the context of this study.
g) Based on the linear equation in f) predict the value of the dependent variable if the value of the independent is 1

Solutions

Expert Solution

a) the dependent variable is annual sales

b) the independent variable is year of experience

c) the coefficient of correlation is 0.9 this means there is strong positive correlation between annual sales and years of experience . this means the more experienced sales man give more annual sales as compared to less experienced sales man

d) the value of coefficient of determination is given by

e) this means that 81% of the total variation is explained by predicted regression equation

f) the given regression equation is

here Y is dependent variable and X is independent variable

so the intercept term

this means that if a sales man has no experience then also he will be able to generate sales of 18 thousand ghana cedis

g)

if

then

Y=20 thousand ghana cedis


Related Solutions

The government of Ghana spends two hundred thousand and fifteen cedis (GHC200,015.00) on goods and services....
The government of Ghana spends two hundred thousand and fifteen cedis (GHC200,015.00) on goods and services. The households spent thirteen thousand and twenty-five cedis (GHC13,025.00) on consumption of goods and services. Two thousand and fifty cedis (GHC2,050.00) was spent on capital goods. Indirect taxes amounted to four hundred and fifty cedis (GHC450.00) and the subsidies of one hundred and fifty cedis (GHC150.00). There was a transfer payment of two hundred cedis (GHC200.00). a. Present the information contained in the above...
A sales manager collected the following data on annual sales for new customer accounts and the...
A sales manager collected the following data on annual sales for new customer accounts and the number of years of experience for a sample of  salespersons. Salesperson Years of Experience Annual Sales ($1000s) 1 1 80 2 3 76 3 4 72 4 6 77 5 8 92 6 8 109 7 9 126 8 9 122 9 10 124 10 11 120 The data on  annual sales  for new customer accounts and  number of years of experience for a sample of  salespersons provided the...
A sales manager collected data on annual sales for new customer accounts and the number of...
A sales manager collected data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. In the Microsoft Excel Online file below you will find a sample of data on years of experience of the salesperson and annual sales. Conduct a regression analysis to explore the relationship between these two variables and then answer the following questions. Salesperson Years of Experience Annual Sales ($1000s) 1 3 79 2 4 92...
A sales manager collected the following data on annual sales for new customer accounts and the...
A sales manager collected the following data on annual sales for new customer accounts and the number of years of experience for a sample of salespersons. Salesperson Years of Experience Annual Sales ($1000s) 1 1 80 2 2 100 3 3 106 4 4 105 5 6 111 6 8 120 7 9 121 8 11 116 9 13 136 10 14 142 The data y= on annual sales($1000s) for new customer accounts and x= number of years of experience...
Recently, there was cyber-attack on one of the banks in Ghana. Millions of Ghana Cedis were...
Recently, there was cyber-attack on one of the banks in Ghana. Millions of Ghana Cedis were transferred from the bank to some individual’s account. In details, explain cryptography and its purpose in providing cybersecurity to firms such as financial institutions.                                 Analyze Kruskal’s algorithm and explain its application in data structures and algorithms. Write a program to implement Kruskal’s algorithms using a high-level programming language. Describe in details abstraction and their relevance in data structures.    Question 2...
A sales manager collected the following data on x = years of experience and y =...
A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is ŷ = 83 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 1 1 80 2 3 97 3 4 102 4 4 107 5 6 103 6 8 116 7 10 119 8 10 123 9 11 127 10 13 136 (a) Compute SST, SSR, and SSE. SST=SSR=SSE= (b) Compute the coefficient...
A sales manager collected the following data on x = years of experience and y =...
A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is ŷ = 82 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 1 1 80 2 3 97 3 4 102 4 4 107 5 6 103 6 8 101 7 10 119 8 10 128 9 11 127 10 13 136 (a) Compute SST, SSR, and SSE. SST=SSR=SSE= (b) Compute the coefficient...
Assuming that the value of 1 Ghana cedis as at today is equal to $0.4100, two...
Assuming that the value of 1 Ghana cedis as at today is equal to $0.4100, two days ago the value of the Ghana cedis was GHC1 to $0.3800. i.calculate the percentage changed of the dollar in cedis. ii.Explain two factors that could have affected this change
The table below shows data collected on the vessel calls for a port in Ghana, from...
The table below shows data collected on the vessel calls for a port in Ghana, from 2007-2016 to study the relationship between the number of Commercial Vessels (C.V.) and Offshore Vessels (O. V.). Year 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 C. V. (X) 527 486 481 558 623 611 606 543 615 673 O. V. (Y ) 67 129 475 719 1175 1053 758 844 910 928 Assuming a linear regression model E(Y |X = x)...
Suppose data were collected on the number of customers that frequented a grocery stores on randomly...
Suppose data were collected on the number of customers that frequented a grocery stores on randomly selected days before and after the governor of the state declared a lock down due to COVID 19. A sample of 6 days before the lockdown were chosen as well as 6 days randomly chosen after the lock down was in place. The number of shoppers each day were as follows: Before lock down After lock down 100 60 110 50 115 70 120...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT