Using the data in the frequency table below compute the correlation
coefficient between advertising expenditure and sales. The data represent
the number of months in which advertising expenditure was in a particular
class AND sales were in a certain range. (17)
(c) Interpret the result, explaining what the coefficient of determination means
and how it can be used. (2) [20]
Sales (R'000s)
10-19 20-29 30-39 40-49 50-59
100-199 12 3 0 2 0
Ad. expend. 200-299 0 8 3 4 0
(R'00s) 300-399 3 5 14 2 3
400-499 0 8 8 20 5
500-599 0 2 12 13 28
TOTAL MAR
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Using the data in the frequency table below compute the correlation coefficient between advertising expenditure and sales. The data represent the number of months in which advertising expenditure was in a particular class AND sales were in a certain range
1 Problem 8 (20 marks) A sales manager for an advertising agency believes there is a relationship between the number of contacts and the amount of the sales. To verify this belief, the following data was collected: Salesperson Number of Contacts Sales (in thousands) 14 24 2 12 14 3 20 28 4 16 30 5 46 80 6 23 30 7 48 90 8 50 85 55 120 10 50 110 9 Assume normality of variables. a) Calculate the...
1 Problem 7 (20 marks) A sales manager for an advertising agency believes there is a relationship between the number of contacts and the amount of the sales. To verify this believe, the following data was collected: Salesperson Number of Contacts Sales (in thousands) 14 24 2 12 14 3 20 28 4 16 30 16 80 23 7 48 90 50 85 55 120 10 SO 110 6 8 9 Assume normality of variables. a) Calculate the coefficient of...
You are projecting future sales and have constructed a linear model using historical sales data for each of the four quarters between years 2011 and 2014. Answer questions 24-28 using the information below Regression Statistics Multiple R Obs Quarter Year Sales Sales 1 1 2011 71 0.995 2 2 2011 49 R Square 0.990 90 3 3 2011 58 Adjusted R Square 0.986 80 4 4 2011 78 Standard Error 1561 70 1 2012 68 Observations 16 60 6 2...
Assume that an imaginary supermarket sells items that are identified by a unique item number which is an integer in range 100 to 499 inclusive. The items are classified in four different categories based on their numbers, and each category defines a different sales tax rate. These four categories along with the range of item numbers included in them, and their specific sales tax rates has been summarized in the following table: Category Item Numbers Sales Tax Rate A 100...
Data were collected during the time period in which a constant number of checkout counters were open. The total number of customers in the store and the waiting times in minutes were recorded. a) Use Excel to construct the scatter plot. b) Determine the linear regression equation between a number of customers and waiting time include that on the graph c) Predict the waiting period when there are 20 customers in the store. d) Show r= coefficient of regression and...
A substance used in biological and medical research is shipped by airfreight to users in cartons of 1,000 ampules. The data below involving 10 shipments, were collected on the number of times the carton was transferred from one aircraft to another over the shipment route (X) and the number of ampules found to be broken upon arrival (Y). i: 1 2 3 4 5 6 7 8 9 10 Xi: 1 0 2 0 3 1 0 1 2 0...
3. Description of each X and data for 27 franchise stores are given below The data (X1, X2, X3, X4, X5, X6) are for each franchise store. X1 annual net sales/$1000 X2 number sq. ft/1000 X3 - inventory I$1000 X4- amount spent on advertising /$1000 X5 size of sales district/1000 families X6 number of competing stores in distric X1 X2 X3 X4 X5 X6 231 3 294 8.2 8.2 11 156 2.2 232 6.9 4.1 12 10 0.5 149 3...
All Greens is a franchise store that sells house plants and lawn and garden supplies. Although All Greens is a franchise, each store is owned and managed by private individuals. Some friends have asked you to go into business with them to open a new All Greens store in the suburbs of San Diego. The national franchise headquarters sent you the following information at your request. These data are about 27 All Greens stores in California. Each of the 27...
All Greens is a franchise store that sells house plants and lawn and garden supplies. Although All Greens is a franchise, each store is owned and managed by private individuals. Some friends have asked you to go into business with them to open a new All Greens store in the suburbs of San Diego. The national franchise headquarters sent you the following information at your request. These data are about 27 All Greens stores in California. Each of the 27...
The data shown below represent the age in weeka) at which babies frut crawl, based on a survey of 12 mother completo porta (8) through (c) below. 5230 44350 47 26 90353062 Clos here to view the fubiectertion constaton coefficient for normal orobabile Click here to view.pronto the standard rom. dirbtitatie, Click here view.pon 20 the standard somal distribution Care for the table critical () Draw a normal probability plot to determine is reasonable to conclude the data come from...