Conduct a regression analysis to analyze net sales and of items Use the results to answer questions 20 24 20 State the null and alternate hypothesisfor the above test A Ho 1 0 H1 10 B Ho 1 0 H1 1 0 C Ho r 0 H1 r 0 D Ho r 0 H1 r0 21 Interpret the meaning of R squared with these particular variables and analysis 22 What is the predicted value of net sales when the number of items sold is 5 Use two decimal places 23 Net sales of $53 60 is one of the actual net sales values when the number of items sold is 5 Calculate the residual (or error) value for this data point Round to two decimal places 24 Discuss whether the assumptions for simple linear regression appear to be met Cut and paste the graph ( or use the embed image tool above) to provide evidence from Minitab to support data set below Customer Store location Type of Customer Items Net Sales Method of Payment Gender Marital Status Age Customer Store location Type of Customer Items Net Sales Method of Payment Gender Marital Status Age 1 A Regular 1 $39 50 Discover Male Married 32 2 B Promotional 1 $102 40 Proprietary Card Female Married 36 3 B Regular 1 $22 50 Proprietary Card Female Married 32 4 A Promotional 5 $100 40 Proprietary Card Female Married 28 5 C Regular 2 $54 00 MasterCard Female Married 34 6 A Regular 1 $44 50 MasterCard Female Married 44 7 A Promotional 2 $78 00 Proprietary Card Female Married 30 8 A Regular 1 $22 50 Visa Female Married 40 9 B Promotional 2 $56 52 Proprietary Card Female Married 46 10 A Regular 1 $44 50 Proprietary Card Female Married 36 11 C Regular 1 $29 50 Proprietary Card Female Married 48 12 C Promotional 1 $31 60 Proprietary Card Female Married 40 13 B Promotional 9 $160 40 Visa Female Married 40 14 B Promotional 2 $64 50 Visa Female Married 46 15 B Regular 1 $49 50 Visa Male Single 24 16 A Promotional 2 $71 40 Proprietary Card Male Single 36 17 A Promotional 3 $94 00 Proprietary Card Female Single 22 18 C Regular 3 $54 50 Discover Female Married 40 19 B Promotional 2 $38 50 MasterCard Female Married 32 20 A Promotional 6 $44 80 Proprietary Card Female Married 56 21 C Promotional 1 $31 60 Proprietary Card Female Single 28 22 A Promotional 4 $70 82 Proprietary Card Female Married 38 23 B Promotional 7 $266 00 American Express Female Married 50 24 C Regular 2 $74 00 Proprietary Card Female Married 42 25 C Promotional 2 $39 50 Visa Male Married 48 26 B Promotional 1 $30 02 Proprietary Card Female Married 60 27 A Regular 1 $44 50 Proprietary Card Female Married 54 28 B Promotional 5 $192 80 Proprietary Card Female Single 42 29 B Promotional 3 $71 20 Proprietary Card Female Married 32 30 C Promotional 1 $18 00 Proprietary Card Female Married 70 31 C Promotional 2 $63 20 MasterCard Female Married 28 32 A Regular 1 $75 00 Proprietary Card Female Married 52 33 B Promotional 3 $63 20 Proprietary Card Female Married 44 34 C Regular 1 $40 00 Proprietary Card Female Married 34 35 A Promotional 5 $105 50 MasterCard Female Married 56 36 C Regular 1 $29 50 MasterCard Male Single 36 37 C Regular 2 $102 50 Visa Female Single 42 38 B Promotional 6 $117 50 Proprietary Card Female Married 50 39 A Promotional 5 $13 23 Proprietary Card Female Married 44 40 B Regular 2 $52 50 Proprietary Card Female Married 58 41 A Promotional 13 $198 80 Proprietary Card Female Married 42 42 B Promotional 4 $19 50 Visa Female Married 46 43 A Regular 2 $123 50 Proprietary Card Female Married 48 44 A Promotional 1 $62 40 Proprietary Card Female Married 54 45 C Promotional 2 $23 80 Proprietary Card Female Married 38 46 C Promotional 2 $39 60 Proprietary Card Female Married 60 47 A Regular 1 $25 00 MasterCard Female Married 46 48 A Promotional 3 $63 64 Proprietary Card Female Married 30 49 A Promotional 1 $14 82 Proprietary Card Female Married 32 50 B Promotional 9 $145 20 MasterCard Female Married 46 51 A Promotional 6 $176 62 Proprietary Card Female Married 38 52 C Promotional 5 $118 80 Proprietary Card Male Married 68 53 A Regular 1 $58 00 Discover Female Single 78 54 C Regular 2 $74 00 Visa Female Single 20 55 B Regular 2 $49 50 MasterCard Female Married 32 56 B Promotional 3 $141 60 Proprietary Card Female Married 38 57 B Promotional 6 $123 10 Proprietary Card Female Married 54 58 C Promotional 2 $80 40 Proprietary Card Female Married 48 59 B Promotional 4 $65 20 MasterCard Female Married 46 60 A Promotional 4 $113 00 Proprietary Card Female Single 50 61 A Promotional 1 $108 80 Proprietary Card Female Married 46 62 A Promotional 3 $59 91 Proprietary Card Female Single 30 63 B Promotional 5 $53 60 Proprietary Card Female Married 54 64 A Promotional 1 $31 60 Proprietary Card Female Single 42 65 A Promotional 2 $49 50 Proprietary Card Female Married 48 66 B Promotional 1 $39 60 Proprietary Card Female Married 62 67 C Promotional 2 $59 50 Proprietary Card Female Married 34 68 A Promotional 5 $146 80 Proprietary Card Female Married 28 69 A Promotional 2 $47 20 Proprietary Card Male Married 46 70 B Promotional 8 $95 05 Proprietary Card Female Married 54 71 C Promotional 5 $155 32 Proprietary Card Female Married 30 72 A Promotional 4 $58 00 MasterCard Female Married 32 73 C Regular 1 $69 00 Proprietary Card Female Single 22 74 A Promotional 2 $46 50 Proprietary Card Female Married 32 75 B Promotional 2 $45 22 Proprietary Card Female Married 74 76 B Promotional 4 $84 74 Proprietary Card Female Married 62 77 B Regular 2 $39 00 Proprietary Card Female Married 42 78 A Promotional 4 $111 14 Proprietary Card Female Married 28 79 A Promotional 3 $86 80 Proprietary Card Female Married 38 80 B Regular 2 $89 00 Discover Female Married 54 81 C Promotional 2 $78 00 MasterCard Female Married 68 82 B Promotional 6 $53 20 Proprietary Card Female Single 30 83 A Promotional 4 $58 50 Visa Female Married 36 84 C Promotional 3 $46 00 Proprietary Card Female Married 44 85 B Regular 2 $37 50 Visa Female Married 44 86 B Promotional 1 $20 80 Proprietary Card Female Married 62 87 C Regular 6 $144 00 MasterCard Female Single 48 88 C Regular 4 $107 00 Proprietary Card Female Married 36 89 C Promotional 1 $31 60 Proprietary Card Female Single 20 90 C Promotional 6 $57 60 Proprietary Card Female Married 42 91 B Promotional 4 $95 20 Proprietary Card Female Married 54 92 A Promotional 1 $22 42 Proprietary Card Female Married 54 93 B Regular 5 $159 75 Proprietary Card Female Married 72 94 A Promotional 17 $229 50 Proprietary Card Female Married 30 95 A Regular 3 $66 00 American Express Female Married 46 96 C Regular 1 $39 50 MasterCard Female Married 44 97 C Promotional 9 $253 00 Proprietary Card Female Married 30 98 C Promotional 10 $287 59 Proprietary Card Female Married 52 99 A Promotional 2 $47 60 Proprietary Card Female Married 30 100 B Promotional 1 $28 44 Proprietary Card Female Married 44

The Answer is in the image, click to view ...

Question: Conduct a regression analysis to analyze net sales and # of items. Use the results to answer questions 20-24. 20. State the null and alternate

Conduct a regression analysis to analyze net sales and # of items. Use the results to answer questions 20-24.

20. State the null and alternate hypothesisfor the above test.

A. Ho: 1=0; H1: 10

B. Ho: 1=0; H1: 1>0

C. Ho: r=0; H1: r>0

D. Ho: r=0; H1: r0

21. Interpret the meaning of R-squared with these particular variables and analysis.

___________________________________________________________________________________

22. What is the predicted value of net sales when the number of items sold is 5? Use two decimal places.

___________________________________________________________________________________

23. Net sales of $53.60 is one of the actual net sales values when the number of items sold is 5. Calculate the residual (or error) value for this data point. Round to two decimal places.

___________________________________________________________________________________

24. Discuss whether the assumptions for simple linear regression appear to be met? Cut and paste the graph ( or use the embed image tool above) to provide evidence from Minitab to support.

___________________________________________________________________________________

data set below:

Customer Store location Type of Customer Items Net Sales Method of Payment Gender Marital Status Age

Customer	Store location	Type of Customer	Items	Net Sales	Method of Payment	Gender	Marital Status	Age
1	A	Regular	1	$39.50	Discover	Male	Married	32
2	B	Promotional	1	$102.40	Proprietary Card	Female	Married	36
3	B	Regular	1	$22.50	Proprietary Card	Female	Married	32
4	A	Promotional	5	$100.40	Proprietary Card	Female	Married	28
5	C	Regular	2	$54.00	MasterCard	Female	Married	34
6	A	Regular	1	$44.50	MasterCard	Female	Married	44
7	A	Promotional	2	$78.00	Proprietary Card	Female	Married	30
8	A	Regular	1	$22.50	Visa	Female	Married	40
9	B	Promotional	2	$56.52	Proprietary Card	Female	Married	46
10	A	Regular	1	$44.50	Proprietary Card	Female	Married	36
11	C	Regular	1	$29.50	Proprietary Card	Female	Married	48
12	C	Promotional	1	$31.60	Proprietary Card	Female	Married	40
13	B	Promotional	9	$160.40	Visa	Female	Married	40
14	B	Promotional	2	$64.50	Visa	Female	Married	46
15	B	Regular	1	$49.50	Visa	Male	Single	24
16	A	Promotional	2	$71.40	Proprietary Card	Male	Single	36
17	A	Promotional	3	$94.00	Proprietary Card	Female	Single	22
18	C	Regular	3	$54.50	Discover	Female	Married	40
19	B	Promotional	2	$38.50	MasterCard	Female	Married	32
20	A	Promotional	6	$44.80	Proprietary Card	Female	Married	56
21	C	Promotional	1	$31.60	Proprietary Card	Female	Single	28
22	A	Promotional	4	$70.82	Proprietary Card	Female	Married	38
23	B	Promotional	7	$266.00	American Express	Female	Married	50
24	C	Regular	2	$74.00	Proprietary Card	Female	Married	42
25	C	Promotional	2	$39.50	Visa	Male	Married	48
26	B	Promotional	1	$30.02	Proprietary Card	Female	Married	60
27	A	Regular	1	$44.50	Proprietary Card	Female	Married	54
28	B	Promotional	5	$192.80	Proprietary Card	Female	Single	42
29	B	Promotional	3	$71.20	Proprietary Card	Female	Married	32
30	C	Promotional	1	$18.00	Proprietary Card	Female	Married	70
31	C	Promotional	2	$63.20	MasterCard	Female	Married	28
32	A	Regular	1	$75.00	Proprietary Card	Female	Married	52
33	B	Promotional	3	$63.20	Proprietary Card	Female	Married	44
34	C	Regular	1	$40.00	Proprietary Card	Female	Married	34
35	A	Promotional	5	$105.50	MasterCard	Female	Married	56
36	C	Regular	1	$29.50	MasterCard	Male	Single	36
37	C	Regular	2	$102.50	Visa	Female	Single	42
38	B	Promotional	6	$117.50	Proprietary Card	Female	Married	50
39	A	Promotional	5	$13.23	Proprietary Card	Female	Married	44
40	B	Regular	2	$52.50	Proprietary Card	Female	Married	58
41	A	Promotional	13	$198.80	Proprietary Card	Female	Married	42
42	B	Promotional	4	$19.50	Visa	Female	Married	46
43	A	Regular	2	$123.50	Proprietary Card	Female	Married	48
44	A	Promotional	1	$62.40	Proprietary Card	Female	Married	54
45	C	Promotional	2	$23.80	Proprietary Card	Female	Married	38
46	C	Promotional	2	$39.60	Proprietary Card	Female	Married	60
47	A	Regular	1	$25.00	MasterCard	Female	Married	46
48	A	Promotional	3	$63.64	Proprietary Card	Female	Married	30
49	A	Promotional	1	$14.82	Proprietary Card	Female	Married	32
50	B	Promotional	9	$145.20	MasterCard	Female	Married	46
51	A	Promotional	6	$176.62	Proprietary Card	Female	Married	38
52	C	Promotional	5	$118.80	Proprietary Card	Male	Married	68
53	A	Regular	1	$58.00	Discover	Female	Single	78
54	C	Regular	2	$74.00	Visa	Female	Single	20
55	B	Regular	2	$49.50	MasterCard	Female	Married	32
56	B	Promotional	3	$141.60	Proprietary Card	Female	Married	38
57	B	Promotional	6	$123.10	Proprietary Card	Female	Married	54
58	C	Promotional	2	$80.40	Proprietary Card	Female	Married	48
59	B	Promotional	4	$65.20	MasterCard	Female	Married	46
60	A	Promotional	4	$113.00	Proprietary Card	Female	Single	50
61	A	Promotional	1	$108.80	Proprietary Card	Female	Married	46
62	A	Promotional	3	$59.91	Proprietary Card	Female	Single	30
63	B	Promotional	5	$53.60	Proprietary Card	Female	Married	54
64	A	Promotional	1	$31.60	Proprietary Card	Female	Single	42
65	A	Promotional	2	$49.50	Proprietary Card	Female	Married	48
66	B	Promotional	1	$39.60	Proprietary Card	Female	Married	62
67	C	Promotional	2	$59.50	Proprietary Card	Female	Married	34
68	A	Promotional	5	$146.80	Proprietary Card	Female	Married	28
69	A	Promotional	2	$47.20	Proprietary Card	Male	Married	46
70	B	Promotional	8	$95.05	Proprietary Card	Female	Married	54
71	C	Promotional	5	$155.32	Proprietary Card	Female	Married	30
72	A	Promotional	4	$58.00	MasterCard	Female	Married	32
73	C	Regular	1	$69.00	Proprietary Card	Female	Single	22
74	A	Promotional	2	$46.50	Proprietary Card	Female	Married	32
75	B	Promotional	2	$45.22	Proprietary Card	Female	Married	74
76	B	Promotional	4	$84.74	Proprietary Card	Female	Married	62
77	B	Regular	2	$39.00	Proprietary Card	Female	Married	42
78	A	Promotional	4	$111.14	Proprietary Card	Female	Married	28
79	A	Promotional	3	$86.80	Proprietary Card	Female	Married	38
80	B	Regular	2	$89.00	Discover	Female	Married	54
81	C	Promotional	2	$78.00	MasterCard	Female	Married	68
82	B	Promotional	6	$53.20	Proprietary Card	Female	Single	30
83	A	Promotional	4	$58.50	Visa	Female	Married	36
84	C	Promotional	3	$46.00	Proprietary Card	Female	Married	44
85	B	Regular	2	$37.50	Visa	Female	Married	44
86	B	Promotional	1	$20.80	Proprietary Card	Female	Married	62
87	C	Regular	6	$144.00	MasterCard	Female	Single	48
88	C	Regular	4	$107.00	Proprietary Card	Female	Married	36
89	C	Promotional	1	$31.60	Proprietary Card	Female	Single	20
90	C	Promotional	6	$57.60	Proprietary Card	Female	Married	42
91	B	Promotional	4	$95.20	Proprietary Card	Female	Married	54
92	A	Promotional	1	$22.42	Proprietary Card	Female	Married	54
93	B	Regular	5	$159.75	Proprietary Card	Female	Married	72
94	A	Promotional	17	$229.50	Proprietary Card	Female	Married	30
95	A	Regular	3	$66.00	American Express	Female	Married	46
96	C	Regular	1	$39.50	MasterCard	Female	Married	44
97	C	Promotional	9	$253.00	Proprietary Card	Female	Married	30
98	C	Promotional	10	$287.59	Proprietary Card	Female	Married	52
99	A	Promotional	2	$47.60	Proprietary Card	Female	Married	30
100	B	Promotional	1	$28.44	Proprietary Card	Female	Married	44

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Trevor Harty, an avid mountain biker, always wanted to start a business selling top-of-the-line mountain bikes and other outdoor supplies. A little over 6 years ago, he and a silent partner opened a...

Conduct a regression analysis to analyze net sales and # of items. State the null and alternate hypothesisfor the above test. A) Ho: 1=0; H1: 10 B) Ho: 1=0; H1: 1>0 C) Ho: r=0; H1: r>0 D) Ho: r=0;...

The objective of the Homework assignment is to provide an opportunity to apply or practice the tools and techniques covered in the course and to provide an opportunity to articulate key concepts...

Board CHAPTER 1 Economics: Foundations and Models n this book, we use economics to answer questions such as the following What determines the prices of goods and services from bottled water to smart...

Exercise Problems on Chapter 14. Multiple Regression Analysis This set of exercise problems has 22 problems, worth a total of 25 points. 1. Multiple regression analysis involves ____ independent...

Rather than demonstrating your ability to recall or search for course data, you will be applying the concepts and principles covered throughout the course in a case study analysis. We will be...

I would like assistance to see if I filled out the attached Form 1040 Schedule C correctly. I am attaching Schedule C, Schedule C Instructions, and the instructions with the information to work the...

.I SELECTED ! Schedule D:Net Long-Term Capital Gains or Losses only its a team work. I need in 3-4 just just scehdule D I. Title: Preparation of a Corporate Income Tax Return Using IRS Form 1120 II....

VIEW THE STEP-BY-STEP SOLUTION TO: Title: ABC Appliance Inherent Risk and Control Design Assessment Prepare Inherent Risks and Control Design Assessment. This course project/case... I.Title: ABC...

Read the Southwest ApplianceInherent Risk andControlDesign I uploadedthat describesTask 3 beginning on page 20. You will also need to refer back to the case description to perform the assigned task....

You used box office gross to predict DVD revenue. Perform a residual analysis for these data (stored in Movie). Based on these results, evaluate whether the assumptions of regression have been...

The volume of a cylinder is given by the formula V = tr h. If r is increased by 50% and the height is reduced by 25%, what will happen to the volume? What is the constant of variation.

It is directly proportional to wand z = 4 when 1=8, (i) find an equation connecting w and (ii) find the values of when w = 18. (iii) calculate the value of w when z = 5. (iv) draw the graph of z...

The folowing trial balance of Watervray Co. doss nat balanca. WATERWAY cO. TRIAL BALANCE JUNE 30, 2020 Debit Credit Cash $3.259 Accounts Receivable $2,852 Supplies 1,189 Equipmant 4,189 Accounts...

Warren owns and manages a small business, which sells pet supplies to high street shops and market traders. Warren sells to customers on credit at 30 days credit terms. (Warren manages all aspects of...

What perspective is conveyed through Indian voices in these documents? Where do you see overlap between the two documents? Are there any places where you sense that these men are holding back from...

Refer to the Racquetball Racket case. Review the problem statement and influence chart that were generated for this case in conjunction with the corresponding exercises in Chapter 2. (If this has not...

You have been hired as an expert in Total Compensation to help design a program that will allow your client to attract, motivate, and retain the right employees with the right skills to help achieve...

Among a group of 5 8 programmers, who know either Java or Python or both, 1 5 only know Java and 1 3 only know Python. What is the probability of randomly choosing a programmer who knows both...

9. What type of competence is important to have and develop in order to strengthen the core value you want others to associate with you?

6. Identify a core value that is important to you and that you would like to strengthen in yourself. Write down this core value. Then complete the follow-ing sentence: This core value is important to...

13. In the statements below, put a cross for the statement you feel characterizes yourself best when you communicate with others. Its not necessarily the way you know you should communicate, but the...