Examlex
An Internet-based retail company that specializes in audio and visual equipment is interested in creating a model to determine the amount of money, in dollars, its customers will spend purchasing products from them in the coming year. In order to create a reliable model, this company has tracked a number of variables on its customers. Below you will find the Excel output related to several of these variables. This company has tried using the customer's annual salary for entire household , the number of children in the household
, and if the customer purchased merchandise from them in the previous year (
in 2015).
-(A) Estimate the regression model. How well does this model fit the data?
(B) Is there a linear relationship between the explanatory variables and the dependent variable? Explain how you arrived at your answer at the 5% significance level.
(C) Use the estimated regression model to predict the amount of money a customer will spend if their annual salary is $45,000, they have 1 child and they were a customer that purchased merchandise in the previous year (2015).
(D) Find a 95% prediction interval for the point prediction calculated in (C). Use a t-multiple = 2.02.
(E) Find a 95% confidence interval for the amount of money spent by all customers sharing the characteristics described in (C). Use a t-multiple = 2.02.
(F) How do you explain the differences between the widths of the intervals in (D) and (E)?
Characteristics
Traits or features that define or distinguish a person, object, or phenomenon.
Situation
A situation is a set of circumstances or a scenario in which an individual finds themselves, influencing their actions or decisions.
Self-direction
The ability of an individual to set their own goals and to take initiative in planning and executing tasks without external influence.
Strong Need
A compelling or critical requirement for something essential or very important.
Q11: (A) Estimate a multiple regression model that
Q25: The financial CEO is given a group
Q35: When the scatterplot appears as a shapeless
Q37: Data tables in spreadsheet simulations are useful
Q41: (A) Estimate a multiple regression model for
Q58: When your handouts contain complex data or
Q62: Which statement about the degree of formality
Q73: When developing your résumé, you should begin
Q78: The optimal solution to any linear programming
Q171: Describe the STAR format for answering behavioral