Question

In: Statistics and Probability

2. The accountant at Superstore wants to determine the relationship between customer purchases at the store,...

2. The accountant at Superstore wants to determine the relationship between customer purchases at the store, Y ($), and the customer monthly salary, X ($). A sample of 15 customers is randomly selected and the results are summarized in the ANOVA table below:                                                                                                      15 Marks
df SS
Regression 1 176952
Residual 13 98236
Total 14    (A)

Coefficients Standard Error t Stat p-value
Intercept 78.58 7.540 1.202 0.035
Salary 0.066 0.013 4.948 0.003

a. Find A.
b. What is the estimated regression equation that relates the amount of customer’s purchase (Y) to the customer’s monthly salary (X)?
c.   Is the regression relationship significant? Use the p-value approach and 2% level of significance.
d.   Compute the coefficient of determination between the amount purchase and the customer’s monthly salary. Interpret the result in the context of the problem.

Solutions

Expert Solution


Related Solutions

To evaluate whether a relationship exists between the number of times a customer visited a store...
To evaluate whether a relationship exists between the number of times a customer visited a store in the past 6 months and the total amount of money the customer spent, we need to generate a scatter plot and correlation coefficient. True or False
A researcher wants to determine if there is a linear relationship between height and weight. The...
A researcher wants to determine if there is a linear relationship between height and weight. The following table represents the data collected. Display the data in a scatter plot on your calculator, draw a quick sketch below. Then find the linear regression and put the line of best fit on the sketch. Then state the value for the correlation coefficient and determine if this is a positive correlation or no correlation using the table in the back of the book....
An environmentalist wants to determine the relationship between the number of fires, in thousands, and the...
An environmentalist wants to determine the relationship between the number of fires, in thousands, and the number of acres burned, in hundreds of thousands. Based on this data, decide if the correlation is significant at alpha = 0.05. Number of fires x 73 74 58 48 80 65 54 49 Number of acres burned y 64 46 22 23 51 12 29 10 5. When x = 61 what is y and what does it mean I this context. 6....
An environmentalist wants to determine the relationship between the number of fires in thousands, and the...
An environmentalist wants to determine the relationship between the number of fires in thousands, and the number of acres burned in hundreds of thousands. Based on the data, decide in the correlation is significant at alpha = 0.05. Number of fires (x) - 73 | 74 | 58 | 48 | 80 | 65 | 54 | 49 Number of acres burned (y) - 64 | 46 | 22 | 23 | 51 | 12 | 29 | 10 Determine...
An environmentalist wants to determine the relationship between the number of fires in thousands, and the...
An environmentalist wants to determine the relationship between the number of fires in thousands, and the number of acres burned in hundreds of thousands. Based on the data, decide in the correlation is significant at alpha = 0.05. Number of fires (x) - 73 | 74 | 58 | 48 | 80 | 65 | 54 | 49 Number of acres burned (y) - 64 | 46 | 22 | 23 | 51 | 12 | 29 | 10 Find...
An architect wants to determine the relationship between the heights (in feet) of a building and...
An architect wants to determine the relationship between the heights (in feet) of a building and the number of stories in the building. The data for a sample of 10 buildings are shown. Stories (x) 64 54 40 31 45 38 42 41 37 40 Height (y) 841 725 635 616 615 582 535 520 511 485 Is there a significant linear correlation between the two variables ? Use α = .05 What would be the best predicted Height of...
A regional transit company wants to determine whether there is a relationship between the age of...
A regional transit company wants to determine whether there is a relationship between the age of a bus and the annual maintenance cost. A sample of 10 buses resulted in the following data: Age of Bus (years) Annual Maintenance Cost ($) 1 350 2 370 2 480 2 520 2 590 3 550 4 750 4 800 5 790 5 950 Instructions: Input the data into an SPSS work sheet making sure that all your variables are labelled appropriately Create...
A researcher wants to determine the relationship between the typing speed of administrative assistants at a...
A researcher wants to determine the relationship between the typing speed of administrative assistants at a major university is related to the time that it takes for the admin assistant to learn to use a new software program and may be used to predict learning time. Data are gathered from 12 departments at the university. Dept Typing speed (words per minute) Learning time (hours) A 48 7 B 74 4 C 52 8 D 79 3.5 E 83 2 F...
A researcher wants to determine whether there is a relationship between age and mode of shopping....
A researcher wants to determine whether there is a relationship between age and mode of shopping. In a random sample of 18- to 21-year-olds, 140 of 185 people shopped online more often than in stores. In a random sample of 40- to 43-year-olds, 90 of 155 shops online more often than in stores. What is the margin of error for a 95% confidence interval for the difference between the proportions of shoppers in these age groups who shop online more...
A regional transit company wants to determine whether there is a relationship between the age of...
A regional transit company wants to determine whether there is a relationship between the age of a bus and the annual maintenance cost. A sample of 10 buses resulted in the following data: Age of Bus (years) Annual Maintenance Cost ($) 1 350 2 370 2 480 2 520 2 590 3 550 4 750 4 800 5 790 5 950 Instructions: Input the data into an SPSS work sheet making sure that all your variables are labelled appropriately Create...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT