Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 12, 2024

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

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Analysis for Financial Management

Authors: Robert C. Higgins

12th edition

1259918963, 9781260140729 , 978-1259918964

Students also viewed these Mathematics questions

Question

★★★★★

In the circuit for Problem 56, after the switch has been closed for a long time, it is opened. How long does it take for the energy stored in the inductor to decrease to 0.10 times its initial value?...

Answered: 1 week ago

Question

★★★★★

21. Under electrostatic conditions, it is found that the excess charge on a conductor is uniformly spread over its surface. What is the shape of the surface?

Answered: 1 week ago

Question

★★★★★

In general, to what extent do you agree with the notion that psychological factors contribute to physical health problems?

Answered: 1 week ago

Question

★★★★★

Classify the following decisions as being characteristic of strategic planning, tactical planning, managerial control, or operational control. Determining the mix of products to manufacture this year...

Answered: 1 week ago

Question

★★★★★

Refine Assumptions for PPE Forecast Provided below is FY2016 information for Medtronic PLC. Medtronic plc Consolidated Statement of Income ($ millions) Apr. 29, 2016 Net sales $29,499 Costs and...

Answered: 1 week ago

Question

★★★★★

The overall manufacturing process to manufacture a part is composed of three main processes. After each process, you have an inspection station. Each unit inspected may have 1 or more defects....

Answered: 1 week ago

Question

★★★★★

this is kimon and he designed a new range of sneakers that are made from recyclable materials such as plastic and rubber. he also made sure that the sole is as comfortable as possible and that these...

Answered: 1 week ago

Question

★★★★★

I'm confused by the pictures here Residential Fire Damage Claims, 2010-2020 14,000 12.000 10,000 8,000 Thousands of Dollars 6,000 - 4.000 2,000 2010 2015 2020 Source: Insurance company records ()...

Answered: 1 week ago

Question

★★★★★

5. Suppose that you get the following regression result from a sample of 277 observations: = 4.57 +0.188x1 - 0.22x2 + 0.171x3 0.92x4 (0.25) (0.040) (0.21) (0.055) (0.33) R = 0.353 The numbers in the...

Answered: 1 week ago

Question

★★★★★

1) As their Consultant, explain the innovation process to them and outline the two (2) reasons innovation would be a better option to commence their business. 2) Outline the three (3) basic steps for...

Answered: 1 week ago

Question

★★★★★

Clearly written rules and policies help eliminate ______ in the workplace

Answered: 1 week ago

Question

★★★★★

QUESTION 24 An organization with a(n) ___ culture is characterized by friendshipswith employees having a high degree of autonomy and flexibility. a.mercenary b.communal c.informal d.fragmented...

Answered: 1 week ago

Previous Question Next Question

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