x
y
14
50
10
55
12
54
11
56
10
58
9
59
6
61
4
62
1.What is the slope?
2. What is the intercept?
3. Using the prediction of x=11 what are the residuals?
4. The sum of squared residuals is 12.038 calculate the standar
deviation of the regression
5. What is the test statistic?
Population 1
59
57
77
60
59
64
72
67
Population 2
61
53
84
53
69
74
64
73
Can it be concluded, from this data, that there is a significant
difference between the two population means?
Let d=(Population 1 entry)−(Population 2 entry)d=(Population 1
entry)−(Population 2 entry). Use a significance level of
α=0.01α=0.01 for the test. Assume that both populations are
normally distributed.
1.State the null and alternative hypotheses for the test
2. Find the value of the standard...
Sample 1
Sample 2
68
76
29
38
52
47
32
36
53
59
35
38
41
36
36
24
52
52
35
40
50
44
75
86
59
69
63
77
49
49
Use the XLMiner Analysis ToolPak to find descriptive statistics
for Sample 1 and Sample 2. Select "Descriptive Statistics" in the
ToolPak, place your cursor in the "Input Range" box, and then
select the cell range A1 to B16 in the sheet. Next, place your
cursor in...
Age
58
69
43
39
63
52
47
31
74
36
Cholesterol level
189
235
193
177
154
191
213
165
198
181
(3) (Continued from Question 2) Based on the sample of 10 men
with ages and cholesterol levels given in the table in Question 2,
answer the following.
(a) At 5% significance level, do the data provide sufficient
evidence to conclude that age is useful as a (linear) predictor of
cholesterol level? State any assumption(s) you make.
(b)...
46
42
37
52
58
36
75
72
90
65
78
80
56
40
48
60
58
76
82
75
38
48
86
88
75
65
45
80
68
47
62
75
56
85
44
70
75
64
67
72
For the data set distribution of Salaries of
the
employees
Arrange in an array (ascending order)
Evaluate the mean, the
median, the mode, the
skew, the average deviation the
standard deviation and the interquartile
range.
Group, on a new...
Question 1 contains the actual values for 12 periods (listed in
order, 1-12). In Excel, create forecasts for periods 6-13 using
each of the following methods: 5 period simple moving average; 4
period weighted moving average (0.63, 0.26, 0.08, 0.03);
exponential smoothing (alpha = 0.23 and the forecast for period 5 =
53); linear regression with the equation based on all 12 periods;
and quadratic regression with the equation based on all 12 periods.
Round all numerical answers to two...
Question 1 contains the actual values for 12 periods (listed in
order, 1-12). In Excel, create forecasts for periods 6-13 using
each of the following methods: 5 period simple moving average; 4
period weighted moving average (0.63, 0.26, 0.08, 0.03);
exponential smoothing (alpha = 0.23 and the forecast for period 5 =
53); linear regression with the equation based on all 12 periods;
and quadratic regression with the equation based on all 12
periods. Round all numerical answers to two...
Consider the table of test scores below:
36
16
61
97
27
37
64
59
91
81
86
39
56
85
26
36
51
18
68
69
78
61
49
29
82
Find the Mean.
Find the Median.
Find the Mode.
Discuss which of these statistics you would use to describe
this set of test scores and back up your choice with some reasoning
from the book or from your notes.