GRADED PROBLEM SET #8
Answer each of the following questions completely. When possible to answer using a complete sentence and offering explanation, please do so. There are a total of 20 points possible in the assignment.
In: Math
Case 1 Instruction (Accounting Application) Use the MS Excel tabular graphical methods of descriptive statistics to summarize the sample data in the data set named PelicanStores in Case 1 folder. The managerial report should contain summaries such as:
1. A frequency and relative frequency distributions for the methods of payment (different cards). (20%)
2. Mean, median, first quartile, third quartile, and sample standard deviation for net sales from regular customers. (20%)
3. Mean, median, first quartile, third quartile, and sample standard deviation for net sales from married female. (20%)
4. Apply the location method to calculate the 60th percentile manually of net sales for each method (card) of payment. Please indicate which card has the highest 60th percentile and show the process. (20%)
5. Apply Chebyshev’s Theorem to calculate the range (i.e. $ to $) of at least 75% of the net sales must fall within for the Proprietary Card payment. (20%) (Hint: What is the z-score for at least 75% of data range?)
Customer | Type of Customer | Items | Net Sales | Method of Payment | Gender | Marital Status | Age |
1 | Regular | 1 | 39.50 | Discover | Male | Married | 32 |
2 | Promotional | 1 | 102.40 | Proprietary Card | Female | Married | 36 |
3 | Regular | 1 | 22.50 | Proprietary Card | Female | Married | 32 |
4 | Promotional | 5 | 153.50 | Proprietary Card | Female | Single | 28 |
5 | Regular | 2 | 54.00 | MasterCard | Female | Married | 34 |
6 | Regular | 1 | 44.50 | MasterCard | Female | Married | 44 |
7 | Promotional | 2 | 78.00 | Proprietary Card | Female | Married | 30 |
8 | Regular | 1 | 22.50 | Visa | Female | Married | 40 |
9 | Promotional | 2 | 56.52 | Proprietary Card | Female | Married | 46 |
10 | Regular | 1 | 44.50 | Proprietary Card | Female | Married | 36 |
11 | Regular | 1 | 107.40 | MasterCard | Female | Single | 48 |
12 | Promotional | 1 | 31.60 | Proprietary Card | Female | Married | 40 |
13 | Promotional | 9 | 160.40 | Visa | Female | Married | 40 |
14 | Promotional | 2 | 64.50 | Visa | Female | Married | 46 |
15 | Regular | 1 | 49.50 | Visa | Male | Single | 24 |
16 | Promotional | 2 | 71.40 | Proprietary Card | Male | Single | 36 |
17 | Promotional | 3 | 94.00 | Proprietary Card | Female | Single | 22 |
18 | Regular | 3 | 54.50 | Discover | Female | Married | 40 |
19 | Promotional | 2 | 38.50 | MasterCard | Female | Married | 32 |
20 | Promotional | 6 | 44.80 | Proprietary Card | Female | Married | 56 |
21 | Promotional | 1 | 31.60 | Proprietary Card | Female | Single | 28 |
22 | Promotional | 4 | 70.82 | Proprietary Card | Female | Married | 38 |
23 | Promotional | 7 | 266.00 | American Express | Female | Married | 50 |
24 | Regular | 2 | 74.00 | Proprietary Card | Female | Married | 42 |
25 | Promotional | 2 | 39.50 | Visa | Male | Married | 48 |
26 | Promotional | 1 | 30.02 | Proprietary Card | Female | Married | 60 |
27 | Regular | 1 | 44.50 | Proprietary Card | Female | Married | 54 |
28 | Promotional | 5 | 192.80 | Proprietary Card | Female | Single | 42 |
29 | Regular | 3 | 71.20 | Visa | Male | Married | 48 |
30 | Promotional | 1 | 18.00 | Proprietary Card | Female | Married | 70 |
31 | Promotional | 2 | 63.20 | MasterCard | Female | Married | 28 |
32 | Regular | 1 | 75.00 | Proprietary Card | Female | Married | 52 |
33 | Promotional | 3 | 77.69 | Visa | Female | Single | 26 |
34 | Regular | 1 | 40.00 | Proprietary Card | Female | Married | 34 |
35 | Promotional | 5 | 105.50 | MasterCard | Female | Married | 56 |
36 | Regular | 1 | 29.50 | MasterCard | Male | Single | 36 |
37 | Regular | 2 | 102.50 | Visa | Female | Single | 42 |
38 | Promotional | 6 | 117.50 | Proprietary Card | Female | Married | 50 |
39 | Promotional | 5 | 13.23 | Proprietary Card | Male | Married | 44 |
40 | Regular | 2 | 52.50 | Proprietary Card | Female | Married | 58 |
41 | Promotional | 13 | 198.80 | Proprietary Card | Female | Married | 42 |
42 | Promotional | 4 | 19.50 | Visa | Female | Married | 46 |
43 | Regular | 2 | 123.50 | Proprietary Card | Female | Married | 48 |
44 | Promotional | 1 | 62.40 | Proprietary Card | Male | Married | 54 |
45 | Promotional | 2 | 23.80 | Discover | Male | Married | 38 |
46 | Promotional | 2 | 39.60 | Proprietary Card | Female | Married | 60 |
47 | Regular | 1 | 25.00 | MasterCard | Female | Married | 46 |
48 | Promotional | 3 | 63.64 | Proprietary Card | Female | Married | 30 |
49 | Promotional | 1 | 14.82 | Proprietary Card | Female | Married | 32 |
50 | Promotional | 9 | 145.20 | MasterCard | Female | Married | 46 |
51 | Promotional | 6 | 176.62 | Proprietary Card | Female | Married | 38 |
52 | Promotional | 5 | 118.80 | Proprietary Card | Male | Married | 68 |
53 | Regular | 1 | 58.00 | Discover | Female | Single | 78 |
54 | Regular | 2 | 74.00 | Visa | Female | Single | 20 |
55 | Regular | 2 | 49.50 | MasterCard | Female | Married | 32 |
56 | Promotional | 3 | 141.60 | Proprietary Card | Female | Married | 38 |
57 | Promotional | 6 | 123.10 | Proprietary Card | Female | Married | 54 |
58 | Promotional | 2 | 80.40 | Discover | Female | Married | 48 |
59 | Promotional | 4 | 65.20 | MasterCard | Female | Married | 46 |
60 | Regular | 4 | 113.00 | American Express | Male | Single | 50 |
61 | Promotional | 1 | 108.80 | Proprietary Card | Female | Married | 46 |
62 | Promotional | 3 | 59.91 | Discover | Female | Single | 30 |
63 | Promotional | 5 | 53.60 | Proprietary Card | Male | Married | 54 |
64 | Promotional | 1 | 31.60 | Proprietary Card | Female | Single | 42 |
65 | Promotional | 2 | 49.50 | Visa | Male | Married | 48 |
66 | Promotional | 1 | 39.60 | Proprietary Card | Female | Married | 62 |
67 | Promotional | 2 | 98.60 | Visa | Female | Single | 34 |
68 | Promotional | 5 | 146.80 | Proprietary Card | Female | Married | 28 |
69 | Promotional | 2 | 47.20 | Visa | Male | Married | 46 |
70 | Promotional | 8 | 95.05 | Proprietary Card | Female | Married | 54 |
71 | Promotional | 5 | 155.32 | Proprietary Card | Female | Married | 30 |
72 | Promotional | 4 | 58.00 | MasterCard | Female | Married | 32 |
73 | Regular | 1 | 69.00 | Proprietary Card | Female | Single | 22 |
74 | Promotional | 2 | 46.50 | American Express | Female | Married | 32 |
75 | Promotional | 2 | 45.22 | Proprietary Card | Female | Married | 74 |
76 | Promotional | 4 | 84.74 | American Express | Female | Married | 62 |
77 | Regular | 2 | 39.00 | Proprietary Card | Female | Married | 42 |
78 | Promotional | 4 | 111.14 | Proprietary Card | Female | Married | 28 |
79 | Promotional | 3 | 86.80 | Proprietary Card | Female | Married | 38 |
80 | Regular | 2 | 89.00 | Discover | Female | Married | 54 |
81 | Promotional | 2 | 78.00 | MasterCard | Female | Married | 68 |
82 | Promotional | 6 | 53.20 | Proprietary Card | Female | Single | 30 |
83 | Promotional | 4 | 58.50 | Visa | Female | Married | 36 |
84 | Promotional | 3 | 46.00 | Proprietary Card | Female | Married | 44 |
85 | Regular | 2 | 37.50 | Visa | Female | Married | 44 |
86 | Promotional | 1 | 20.80 | Proprietary Card | Female | Married | 62 |
87 | Regular | 6 | 144.00 | MasterCard | Female | Single | 48 |
88 | Regular | 4 | 107.00 | Proprietary Card | Female | Married | 36 |
89 | Promotional | 1 | 31.60 | Proprietary Card | Female | Single | 20 |
90 | Promotional | 6 | 57.60 | Proprietary Card | Female | Married | 42 |
91 | Promotional | 4 | 105.73 | American Express | Male | Married | 54 |
92 | Regular | 1 | 44.85 | American Express | Male | Married | 65 |
93 | Regular | 5 | 159.75 | Proprietary Card | Female | Married | 72 |
94 | Promotional | 17 | 229.50 | Proprietary Card | Female | Married | 30 |
95 | Regular | 3 | 66.00 | American Express | Female | Married | 46 |
96 | Regular | 1 | 39.50 | MasterCard | Female | Married | 44 |
97 | Promotional | 9 | 253.00 | Proprietary Card | Female | Married | 30 |
98 | Regular | 10 | 287.59 | American Express | Male | Single | 44 |
99 | Promotional | 2 | 47.60 | Proprietary Card | Female | Married | 30 |
100 | Promotional | 1 | 75.42 | Proprietary Card | Male | Single | 28 |
In: Math
We need to find the confidence interval for the SLEEP variable. To do this, we need to find the mean and standard deviation with the Week 1 spreadsheet. Then we can the Week 5 spreadsheet to find the confidence interval.
First, find the mean and standard deviation by copying the SLEEP variable and pasting it into the Week 1 spreadsheet. Write down the mean and the sample standard deviation as well as the count. Open the Week 5 spreadsheet and type in the values needed in the green cells at the top. The confidence interval is shown in the yellow cells as the lower limit and the upper limit.
1. Give and interpret the 95% confidence interval for the hours of sleep a student gets. Change the confidence level to 99% to find the 99% confidence interval for the SLEEP variable.
2. Give and interpret the 99% confidence interval for the hours of sleep a student gets.
3. Compare the 95% and 99% confidence intervals for the hours of sleep a student gets. Explain the difference between these intervals and why this difference occurs.
In the Week 2 Lab, you found the mean and the standard deviation for the HEIGHT variable for both males and females. Use those values for follow these directions to calculate the numbers again.
(From Week 2 Lab: Calculate descriptive statistics for the variable Height by Gender. Click on Insert and then Pivot Table. Click in the top box and select all the data (including labels) from Height through Gender. Also click on “new worksheet” and then OK. On the right of the new sheet, click on Height and Gender, making sure that Gender is in the Rows box and Height is in the Values box. Click on the down arrow next to Height in the Values box and select Value Field Settings. In the pop up box, click Average then OK. Write these down.
Then click on the down arrow next to Height in the Values box again and select Value Field Settings. In the pop up box, click on StdDev then OK. Write these values down.)
You will also need the number of males and the number of females in the dataset. You can either use the same pivot table created above by selecting Count in the Value Field Settings, or you can actually count in the dataset. Then use the Week 5 spreadsheet to calculate the following confidence intervals. The male confidence interval would be one calculation in the spreadsheet and the females would be a second calculation.
4. Give and interpret the 95% confidence intervals for males and females on the HEIGHT variable. Which is wider and why?
5. Give and interpret the 99% confidence intervals for males and females on the HEIGHT variable. Which is wider and why?
6. Find the mean and standard deviation of the DRIVE variable by copying that variable into the Week 1 spreadsheet. Use the Week 4 spreadsheet to determine the percentage of data points from that data set that we would expect to be less than 40. To find the actual percentage in the dataset, sort the DRIVE variable and count how many of the data points are less than 40 out of the total 35 data points. That is the actual percentage. How does this compare with your prediction? Mean ______________ Standard deviation ____________________ Predicted percentage ______________________________ Actual percentage _____________________________ Comparison ___________________________________________________ ______________________________________________________________
7. What percentage of data would you predict would be between 40 and 70 and what percentage would you predict would be more than 70 miles? Use the Week 4 spreadsheet again to find the percentage of the data set we expect to have values between 40 and 70 as well as for more than 70. Now determine the percentage of data points in the dataset that fall within this range, using same strategy as above for counting data points in the data set. How do each of these compare with your prediction and why is there a difference? Predicted percentage between 40 and 70 ______________________________ Actual percentage _____________________________________________ Predicted percentage more than 70 miles ________________________________ Actual percentage ___________________________________________ Comparison ____________________________________________________ _______________________________________________________________ Why? __________________________________________________________ ________________________________________________________________
Sleep (hours) |
7 |
7 |
5 |
7 |
6 |
8 |
7 |
8 |
5 |
8 |
8 |
4 |
8 |
8 |
6 |
8 |
8 |
8 |
7 |
10 |
6 |
7 |
8 |
5 |
8 |
7 |
7 |
4 |
9 |
8 |
7 |
7 |
8 |
8 |
10 |
Height (inches) |
61 |
62 |
63 |
63 |
64 |
65 |
65 |
66 |
66 |
67 |
67 |
67 |
67 |
68 |
68 |
69 |
69 |
69 |
69 |
69 |
69 |
69 |
70 |
70 |
70 |
70 |
70 |
71 |
71 |
71 |
73 |
73 |
74 |
74 |
75 |
In: Math
In: Math
Faced with rising fax costs, a firm issued a guideline that transmissions of 8 pages or more should be sent by 2-day mail instead. Exceptions are allowed, but they want the average to be 8 or below. The firm examined 37 randomly chosen fax transmissions during the next year, yielding a sample mean of 10.22 with a standard deviation of 4.88 pages. |
(a-1) |
Find the test statistic. (Round your answer to 4 decimal places.) |
The test statistic |
(a-2) |
At the .01 level of significance, is the true mean greater than 8? |
||||
|
(b) |
Use Excel to find the right-tail p-value. (Round your answer to 4 decimal places.) |
p-value |
In: Math
Use the Central Limit Theorem to find the mean and standard error of the mean of the sampling distribution. Then sketch a graph of the sampling distribution. The mean price of photo printers on a website is $228 with a standard deviation of $61. Random samples of size 34 are drawn from this population and the mean of each sample is determined. What is the standard deviation of the distribution of sample means ? (Type an integer or decimal rounded to three decimal places as needed.)
In: Math
A study of 800 homeowners in a certain area showed that the average value of the homes is $182,000 and the standard deviation is $15,000. Find the probability that the mean value of these homes is less than $185,000.
Round answer to 4 decimal places.
In: Math
1) Using the tdist function, calculate exact p-values for a two tailed test for the following test statistics (6 points)
a) 2.14, df = 79 (2 points) b) 3.68, df = 13 (2 points) c) 1.78, df = 117 (2 points)
In: Math
Based on data from a college, scores on a certain test are normally distributed with a mean of 1518 and a standard deviation of 324.
Standard score Percent
-3.0 0.13
-2.5 0.62
-2 2.28
-1.5 6.68
-1 15.87
-0.9 18.41
-0.5 30.85
-0.1 46.02
0 50.00
0.10 53.98
0.5 69.15
0.9 81.59
1 84.13
1.5 93.32
2 97.72
2.5 99.38
3 99.87
3.5 99.98
Find the percentage of scores greater than
2166
Find the percentage of scores less than
1194
Find the percentage of scores between
870
and
1680.
In: Math
4000 B.C 1850 B.C. 150 A.D.
131 129 128
138 134 138
125 136 138
129 137 139
132 137 141
135 130 142
132 136 136
134 138 145
140 134 137
The values in the table below are measured maximum breadths (in millimeters) of male skulls from different epochs. Changes in head shape over time suggest that interbreeding occurred with immigrant populations. Use a 0.05 significance level to test the claim that the different epochs all have the same mean.
Find the p value
In: Math
A random sample of size n=500 yielded p̂ =0.08
a) Construct a 95% confidence interval for p.
b) Interpret the 95% confidence interval.
c) Explain what is meant by the phrase "95% confidence
interval."
In: Math
Please try to type your solution for this question, so I can read it without a problem. I truly appreciate you for typing in advance.
The Question:
For some Mechanical Engineer students, data for 224 student’s GPAs in their first 4 semesters of college were compared using several predictors, namely HSM, HSS, HSE, SATM, and SATV. Here significant level α is 0.05.
Then, the researcher fit a regression model and got the following results (intercept is included in the model):
ANOVA Table
Source |
DF |
Sum of Squares |
Mean Squares |
F ratio |
Model(Reg) |
(A) |
(D) |
(E) |
(F) |
Error(Residual) |
(B) |
105.65 |
0.4846433 |
Prob>F |
Total |
(C) |
135.46 |
<0.001 |
Parameter Estimates Table
Term |
Estimate |
Std Error |
t Ratio |
Prob>|t| |
Intercept |
0.2187920884 |
0.40332538 |
0.54 |
0.5880 |
HSM |
0.1464842907 |
0.03900487 |
(G) |
0.0002 |
HSS |
0.0274662163 |
0.03728366 |
0.74 |
0.4621 |
HSE |
0.0770581216 |
0.03929423 |
1.96 |
0.0511 |
SATM |
0.0009273573 |
0.00067983 |
1.36 |
0.1739 |
SATV |
.0004012914 |
0.00058484 |
-0.69 |
0.4933 |
In: Math
Describe the sampling distribution of ModifyingAbove p with caret. Assume the size of the population is 25 comma 000. nequals900, pequals0.235 Describe the shape of the sampling distribution of ModifyingAbove p with caret. Choose the correct answer below. A. The shape of the sampling distribution of ModifyingAbove p with caret is not normal because n less than or equals 0.05 Upper N and np left parenthesis 1 minus p right parenthesis greater than or equals 10. B. The shape of the sampling distribution of ModifyingAbove p with caret is approximately normal because n less than or equals 0.05 Upper N and np left parenthesis 1 minus p right parenthesis greater than or equals 10. C. The shape of the sampling distribution of ModifyingAbove p with caret is approximately normal because n less than or equals 0.05 Upper N and np left parenthesis 1 minus p right parenthesis less than 10. D. The shape of the sampling distribution of ModifyingAbove p with caret is not normal because n less than or equals 0.05 Upper N and np left parenthesis 1 minus p right parenthesis less than 10. Determine the mean of the sampling distribution of ModifyingAbove p with caret. mu Subscript ModifyingAbove p with caret Baseline equals 0.235 0.235 (Round to three decimal places as needed.) Determine the standard deviation of the sampling distribution of ModifyingAbove p with caret. sigma Subscript ModifyingAbove p with caret Baseline equals nothing (Round to three decimal places as needed.)
In: Math
this question, but calculate the 90% confidence interval for the coefficient for cable by hand (but use the SE from the software output) and do the test whether age and number of TVs should be dropped by hand (use ANVOA table to get p-value and confirm with software).
The data in the table below contains observations on age, sex (male = 0, female = 1), number of television sets in the household, cable (no = 0, yes = 1), and number of hours of television watched per week. Using hours of television watched per week as the response, you can use Minitab's Regress or R's lm() command [e.g., model <- lm(hours~age+sex+num.tv+cable)] to fit a least squares regression model to all the other given variables.
Age: | 22,22,50,43,54,24,15,23,34,18,58,19,26,15,21,30,37,44,29,27,30,17,15,21,47,26,13,39,22,20,14,47,21,38,23,32,19,15,21,18 |
Sex: | 0,0,1,1,0,1,0,1,1,1,0,0,0,1,1,0,1,0,0,1,1,0,1,0,0,1,1,0,1,1,1,1,0,0,1,1,1,0,1,0 |
Num. TV: | 2,2,1,1,1,1,2,1,1,1,2,1,1,1,1,2,2,2,1,1,2,1,2,1,1,1,2,2,1,1,1,1,1,1,2,1,2,1,1,2 |
Cable: | 1,0,1,1,1,0,1,0,1,0,1,0,0,0,0,0,1,1,1,0,0,1,1,1,1,0,0,0,1,0,0,1,0,1,0,0,1,0,0,1 |
Hours TV: | 28,16,18,20,25,14,21,7,12,14,15,12,10,11,12,18,17,20,21,15,17,18,13,21,23,11,10,21,13,12,10,19,12,21,8,16,13,9,11,21 |
What is the estimated value of the regression coefficient for age? [2 pt(s)]
Tries 0/3 |
What is the estimated value of the regression coefficient for cable? [2 pt(s)]
Tries 0/3 |
According to the regression equation, which of the following
statements is true?
Females watch television 3.577 hours more per week than
males.
Males watch television 3.577 hours more per week than
females.
From the data given, one can not tell which gender watches more
television per week.
Females watch television approximately the same number of hours per
week as males.
[2 pt(s)]
Tries 0/1 |
What is the value of the test-statistic for the overall regression significance test? [3 pt(s)]
Tries 0/3 |
What are the degrees of freedom associated with the test-statistic? Numerator: Denominator: [1 pt(s)]
Tries 0/3 |
Select the interval below that contains the p-value for this
test.
p-value ≤ 0.001
0.001 < p-value ≤ 0.01
0.01 < p-value ≤ 0.05
0.05 < p-value ≤ 0.1
0.1 < p-value ≤ 0.25
p-value > 0.25
[3 pt(s)]
Tries 0/3 |
Compute a 90% confidence interval for the coefficient for cable. Lower Bound: Upper Bound: [3 pt(s)]
Tries 0/3 |
Compute a 95% confidence interval for the mean number of hours watched by 18-year old females with cable and 2 TV sets. Lower Bound: Upper Bound: [3 pt(s)]
Tries 0/3 |
Compute a 95% prediction interval for the mean number of hours watched by 18-year old females with cable and 2 TV sets. Lower Bound: Upper Bound: [3 pt(s)]
Tries 0/3 |
Test whether age and number of TV sets are needed in the model or should be dropped. What is the value of the test-statistic? [3 pt(s)]
Tries 0/3 |
What are the degrees of freedom associated with this test? Numerator: Denominator: [1 pt(s)]
Tries 0/3 |
Select the interval below that contains the p-value for this
test.
p-value ≤ 0.001
0.001 < p-value ≤ 0.01
0.01 < p-value ≤ 0.05
0.05 < p-value ≤ 0.1
0.1 < p-value ≤ 0.25
p-value > 0.25
[3 pt(s)]
Tries 0/3 |
In: Math
You are conducting a multinomial Goodness of Fit hypothesis test for the claim that the 4 categories occur with the following frequencies:
H o : p A = 0.15 ; p B = 0.4 ; p C = 0.3 ; p D = 0.15 Complete the table.
Report all answers accurate to three decimal places.
1)
category | observed frequency | expected frequency | residual (chi-square) component |
A | 10 | ||
B | 25 | ||
C | 16 | ||
D | 17 |
2) What is the chi-square test-statistic for this data?
χ 2 =
Significance level alpha is 0.005.
3) What is the p-value?
p-value =
4) What would be the conclusion of this hypothesis test?
A)Reject the Null Hypothesis
B)Fail to reject the Null Hypothesis
Report all answers accurate to three decimal places.
In: Math