Question
Transcribed Text
Student
Midterm
Final Exam
Place scatter plot beginnin in E2, expand to N22
1
76
65
2
84
90
3
79
68
4
88
84
5
76
61
6
66
79
7
77
73
8
94
93
9
66
60
10
92
86
11
80
53
12
87
83
13
86
55
14
63
72
15
92
87
16
75
89
17
69
81
18
92
94
19
79
78
20
60
71
21
68
84
22
71
74
23
61
74
Midterm =
75
24
68
54
Final Prediction =
25
76
94
You should create an equation for the prediction
26
72
79
27
99
89
28
58
53
29
82
78
30
72
82
31
77
69
32
95
98
33
72
93
34
71
80
35
72
82
36
96
96
37
72
61
38
89
84
39
94
97
40
85
89
41
60
72
42
66
93
43
96
84
44
83
87
45
88
99
46
92
97
47
78
92
48
85
93
49
91
78
50
74
82
51
96
99
52
80
72
53
62
79
54
70
75
55
87
90
56
89
95
Price
Demand
Place scatter plot beginnin in D2, expand to L22
$11.00
2180
$13.00
2020
$15.00
1980
$17.00
1900
Which Trendline model is best?
Enter the name of the best trendline model.
X
Y
Place scatter beginning in D2 and expand to K20
1
-102.8
1.5
-36.4
2
-4.7
2.5
-17.0
3
-5.3
3.5
-4.2
4
-1.5
4.5
-0.2
5
0.0
5.5
0.1
6
0.8
6.5
3.4
7
9.1
7.5
9.5
8
22.5
8.5
54.9
9
103.8
9.5
142.0
10
25.2
10.5
193.2
X
Y
Place scatter beginning in D24 and expand to K64
10
16.04
10.5
13.46
11
13.46
11.5
11.70
12
13.36
12.5
11.74
13
10.63
13.5
11.05
14
11.35
14.5
10.04
15
11.14
15.5
11.04
16
11.31
16.5
10.56
17
10.89
17.5
9.00
18
8.18
18.5
8.71
19
7.41
19.5
7.62
20
5.13
X
Y
Place scatter beginning in D47 and expand to K43
1
3.45
2
4.39
3
6.22
4
7.58
5
9.62
6
8.25
7
6.96
8
11.20
9
12.74
10
16.26
11
15.12
12
29.33
13
35.78
14
44.23
15
34.53
16
62.13
17
54.54
18
62.02
19
110.62
Pre MBA Post MBA
Age
Salary
Salary
Place your scatter plot beginning in E2
30
$85,000
$105,000
and expand to L20. Include a linear
34
$87,000
$100,000
trend model, equation and R².
28
$70,000
$100,000
35
$95,000
$125,000
Answer:
23
$52,000
$60,000
28
$47,000
$70,000
39
$70,000
$130,000
26
$55,000
$75,000
30
$75,000
$110,000
24
$50,000
$80,000
23
$42,500
$85,000
28
$70,000
$90,000
28
$55,000
$70,000
27
$60,000
$90,000
26
$65,000
$80,000
31
$90,000
$110,000
35
$87,000
$105,000
39
$110,000
$125,000
24
$37,000
$70,000
30
$60,000
$75,000
35
$73,000
$95,000
Place your scatter plot beginning in E23
28
$57,000
$75,000
and expand to L41.
23
$45,000
$80,000
Include a polynomial degree 3 trend model, equation and R².
29
$65,000
$90,000
33
$85,000
$100,000
Couple's Income
Bride's age
Wedding cost
Attendance
Value Rating
$98,000
27
$47,000
150
3
$72,000
29
$42,000
200
5
$90,000
28
$30,500
150
3
$43,000
19
$30,000
250
3
$100,000
30
$30,000
300
3
$78,000
35
$26,000
200
5
$75,000
27
$24,000
200
5
$53,000
31
$14,000
100
1
$45,000
32
$5,000
50
5
$130,000
22
$60,700
300
3
$157,000
23
$52,000
350
1
$86,000
25
$34,000
250
3
$65,000
24
$28,000
250
3
$73,000
25
$25,000
150
5
$64,000
25
$24,000
200
1
$75,000
25
$20,000
200
5
$67,000
30
$20,000
200
5
$75,000
19
$19,000
150
3
$52,000
23
$19,000
200
1
$64,000
22
$18,000
150
1
$55,000
28
$16,000
100
5
$62,000
24
$13,000
150
1
$40,000
26
$7,000
50
3
$67,000
27
$22,000
200
5
$62,000
21
$20,000
100
1
Place first scatter beginning in G2 and expand to N20.
Place first scatter beginning in G22 and expand to N62.
Place first scatter beginning in G44 and expand to N41.
Solution Preview
These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.
By purchasing this solution you'll be able to access the following files:
Solution.xlsx.
Return to homework library