Lowes, A home improvement store has granted authorization for its
Market research department will conduct an analysis of customers who are currently in the market.
been issued Lowes Card. Market research
Department hopes to determine the important variables that explain
Variation in purchasing. After these variables have been determined
This department hopes to draw in new customers.
It is expected that there will be a large volume of sales. Twenty-five customers
These variables were randomly selected.
These were also recorded
Your Name
= Average monthly
purchases (in dollars) at Lowes
x1
= Customer age
x2
= Customer family income
x3
= Family size
The Excel worksheet below shows a part of the data. A
These data were used in the development of a regression model. This partial
Below are data and Excel regression output (complete data).
All twenty-five of our customers were used in the analysis. You can find this here
Answer the following questions with output
Observation |
Purchase Volume ($) |
Age |
Family Income ($) |
Families |
1 |
75 |
42 |
$ 29,000 |
4 |
2 |
129 |
36 |
25,000 |
2 |
3 |
105 |
38 |
25,000 |
2 |
4 |
42 |
54 |
17,000 |
3 |
5 |
17 |
49 |
15,000 |
5 |
6 |
? |
? |
? |
? |
7 |
? |
? |
? |
? |
8 |
? |
? |
? |
? |
9 |
? |
? |
? |
? |
10 |
? |
? |
? |
? |
11 |
? |
? |
? |
? |
12 |
? |
? |
? |
? |
13 |
? |
? |
? |
? |
14 |
? |
? |
? |
? |
15 |
? |
? |
? |
? |
16 |
? |
? |
? |
? |
17 |
? |
? |
? |
? |
18 |
? |
? |
? |
? |
19 |
? |
? |
? |
? |
20 |
? |
? |
? |
? |
21 |
105 |
30 |
26,000 |
2 |
22 |
121 |
27 |
18,250 |
3 |
23 |
14 |
62 |
10,250 |
3 |
24 |
37 |
50 |
18,100 |
2 |
25 |
43 |
26 |
24,500 |
4 |
SUMMARY EXPUT |
||||
Statistical Regression |
||||
Multiple R |
||||
R Square |
||||
Adjusted R Square |
||||
Standard Error |
32.27240363 |
|||
Observations |
25 |
|||
ANOVA |
||||
df |
SS |
MS |
F |
|
Regression |
||||
Residual |
21871.66876 |
|||
Total |
38517.76 |
|||
Coefficients |
Standard Error |
t Stat |
P-value |
|
Intercept |
87.78972947 |
25.46767899 |
||
Age X1 |
-0.970467501 |
0.586041665 |
||
Family Income X2 |
0.002334262 |
0.000745097 |
||
Family Size X3 |
-8.723322293 |
7.495492501 |
12.
Requirements
Examine
Below is the correlation matrix.
Purchase Volume ($) |
Age |
Family Income ($). |
Families |
|
Purchase Volume ($) |
1 |
|||
Age |
-0.41 |
1 |
||
Family Income ($). |
0.46 |
0.05 |
1 |
|
Families |
-0.24 |
0.50 |
0.27 |
Is there a problem with multicollinearity?
This regression model? Let’s briefly and clearly discuss the criteria.
You can use this method to find your answer. Multicollinearity may be indicated
Determine the variables that are relevant.
Why Choose Us
Quality Papers
We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.
Professional Academic Writers
Over the years, our Acme Homework has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keep up with the rising Academic Trends.
Affordable Prices
Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.
On-Time delivery
We pay strict attention on deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.
100% Originality
At Custom Paper Help, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.
Customer Support 24/7
Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email: support@acmehomework.com.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Our Services
Custom Paper Help has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.
Essays
At Custom Paper Help, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.
Admissions
Admission and Business Papers
Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.
Editing
Editing and Proofreading
Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.
Coursework
Technical papers
We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.