Statistics Homework

profilenancy2014
excel_homework_2.xlsx

Instructions

Problem # Point Value Your Points
1 4
2 4
3 4
4 6
5 2
6 16
7 4
8 4
9 15
10 14
11 5
12 12
13 4
14 6
100 0

  Directions: All answers are to be contained in one excel file. Please do not delete this tab (the instructions tab). This is an open book, open notes exam. The one limitation is that you may not work with other people. This test must be completed independently. Be sure your name is on your document. Good luck!

Q1

Q1. What is the risk of performing the t-test using pooled variance, if the variances between the two samples are actually unequal (i.e. fail the F test)? (Select the correct answer from the choices below.) A. You will fail to adjust for sample size. B. You may falsely accept or reject the null hypothesis. C. Your result will only be applicable for a one-tail t-test.

Q2

Q2. Which measure of central tendency can be used for both numerical and categorical variables? (Select the correct answer from the choices below.) A. Median B. Geometric Mean C. Mode D. Arithmetic Mean  

Q3

Q3. The probability that a new advertising campaign will increase sales is assessed as being 0.80. The probability that the cost of developing the new ad campaign can be kept within the original budget allocation is 0.40. Assuming that the two events are independent, the probability that the cost is kept within budget and the campaign will increase sales is: (Select the correct answer from the choices below.)   A. 0.32 B. 0.68 C. 0.88 D. 0.20

Q4

Q4.
Age in Years Number of Students (f)
Under 21 4946
21 - 25 4808
26 - 30 2673
31 - 35 29036
Over 35 525
Total 41988
A. Find P (B)
B. Find P (E)

The age distribution of students at a community college is given below:

Suppose a student is selected at random. Let A = the event the student is under 21 B = the event the student’s age is between 21 and 25 C = the event the student’s age is between 26 and 30 D = the event the student’s age is between 31 and 35 E = the event the student’s age is 35 and under

Q5

Q5: Statistical significance can be determined from descriptive statistical analysis alone? (Select the correct answer from the choices below.) A. True B. False

Q6

Q6. Refer to the tab titled "thrombosus data" for data required to solve this problem. You are looking at patients supported by a Left Ventricular Assist Device (LVAD). Within this patient group, you have Group No (those who have not had a thrombus event) and Group Yes (those who have had a thrombus event). A thrombus event is an event in which a blood clot developed in the LVAD. Data has been sorted in the tab "Thrombus Event" to list "No" thrombus event patients first. In addition, you have data related to time (in days) that the patient has been supported by the LVAD. You'd like to know if patients in Group No have been supported for the same amount of time on their LVADs as those in Group Yes. You believe that the longer a patient is supported by an LVAD , the more likely the patient is to have a thrombus event. Therefore, you want to show statistically that Group Yes has a longer average time spent on the LVAD. You will need to answer the questions below to see what the results actually show. Answer questions 1 through 5 below.

#1. What is your null hypothesis (H0) for this research topic? (Select either A or B from below.) A. There is no difference in days supported by an LVAD between Group No and Group Yes. B. Group Yes patients have been supported by an LVAD for more days than Group No patients.

#2. Calculate the average time (in days) supported by an LVAD for each group. (Use Excel formula.) A. ______ days for Group No B. ______ days for Group Yes

#3. Calculate the variance for time (in days) supported by an LVAD for each group. (Use Excel formula.) A. ______ days for Group No B. ______ days for Group Yes

#4. What is the sample size (n) for each group? A. ______ Group No B. ______ Group Yes

#5. Perform the appropriate statistical test to test for significance between the the two groups. Note, you can use the "data analysis toolpak" to get your result. You will need to format the data to be able to run the analsysis. Based on your results: A. What p-value did you find? B. Describe what your findings mean. Is there a significant difference between the groups? C. Would you accept or reject the null hypothesis?

Q7

Q7. Which words can be used to describe quantitative research methods? (Select all that apply.) A. Words B. Numbers C. Structured D. Randomly selected samples E. Focus is on the research subject's view F. Objective

Q8

Q8. A medical device manufacturer claims to have developed a thin AICD that contains a mean of no less than 41 Joules of stored energy. From previous studies, it is believed that stored energy for AICDs is normally distributed with a standard deviation of 2 Joules. A consumer group has decided to try to discover if the claim appears true. They take a sample of 20 AICDs and find that the mean of stored energy is 40.6 Joules.   Referring to the information above, the appropriate hypotheses to determine if the manufacturer's claim appears reasonable is:   A. H0: μ ≥ 41 versus H1: μ < 41 B. H0: μ > 41 versus H1: μ ≠ 41 C. H0: μ ≤ 41 versus H1: μ > 41 D. H0: μ ≥ 40.6 versus H1: μ < 40.6

Q9

"category title" "category title"
"category title" "count" "count" "total"
"category title" "count" "count" "total"
"total" "total" "total"

Q9. Refer to the tab titled "Tobacco Use" for data required to solve this problem. The premise of this problem is that you are looking at a group of patients with heart failure. Patients either have ischemic cardiomyopathy (ICM) or non-ischemic cardiomyopathy (NICM). You have gathered information about their smoking history. You are wondering if there is a relationship between these 2 variables (i.e. type of heart disease and history of tobacco use). (Ischemic cardiomyopathy is a result of plaque buildup in vessels.) Answer questions 1 through 5 below.

#1. What type of variables do you have? Numerical or Categorical? A. Type of heart disease is a __________________ variable. B. History of smoking is a ___________________ variable.

#2. Which of the two variables is the independent variable (type of heart disease or history of smoking)?

#3. If you were to test the relationship between the 2 variables, which inferential statistical test would you use?

#4. What would your hypotheses be? A. The null hypothesis (H0) would state: _______ B. The alternative hypothesis (H1) would state: _________

#5. Setup a contingency table for this problem in the table below. Label all 4 categories in the fields that state "category title". Enter the counts in the fields that state "count". Calculate the totals for each field that states "total".

Q10

Q10. Refer to the tab titled "Financial Data" for data required to solve this problem. This data represents financial data associated with 4 different types of readmissions. Use the column titled "Cause of Readmission" and the column titled "Contribution Margin" to answer the following questions. Answer questions 1 through 4 below.

#1. Calculate the mean of the contribution margin for each of the 4 categories under "cause for readmission". (Use Excel formula.) A. Stroke: mean = ______ B. GI Bleed: mean = ______ C. Other: mean = ______ D. Vtach &/or AICD Fire: mean = ______

#2. Construct a column chart that shows the means of the 4 groups. Label the chart appropriately.

#3. Using 95% CI, calculate the upper and lower confidence limits for the "contribution margin" data for the category "other". Assume t-distribution.

#4. Describe the meaning of the confidence limits that you just calculated.

Q11

Q11. This question is related to simple linear regression. In simple linear regression, the goal is to determine if there is a linear change in the _______ variable based on a change in the ______ variable. The dependent variable will always be a ________ variable. If a negative relationship is found, this means that as the independent variable _______, the dependent variable _______. (Select the correct answer from the choices below to correctly fill in the blank words.) A. dependent, independent, categorical, increases, decreases B. independent, dependent, categorical, increases, decreases C. independent, dependent, categorical, decreases, increases C. dependent, independent, numerical, increases, decreases D. dependent, independent, numerical, decreases, increases E. independent, dependent, numerical, decreases, increases

Q12

Q12. Refer to the tab titled "Financial Data" for data required to solve this problem. This data represents financial data associated with 4 different types of readmissions. Use the column titled "Cause of Readmission" and the column titled "Length of Stay" to answer the following questions. Answer questions 1 through 5 below.

#1. Arrange the data in a format so that you can perform a one-way ANOVA to test for significant difference in Length of Stay between the 4 causes for readmissions.

#2. What is an appropriate null hypothesis (H0)for this data analysis?

#3. Perform a one-way ANOVA to test for significant difference in Length of Stay between the 4 causes for readmissions. (It is recommended that you use the data analysis toolpak addin to perform the test.)

#4. Based on the F statistic from your ANOVA test, woul d you accept or reject your null hypothesis? Explain why.

#5. Based on the p-value from your ANOVA test, woul d you accept or reject your null hypothesis ? Explain why.

Q13

Q13. According to the empirical rule, if the data form a "bell-shaped" normal distribution, what percent of the observations will be contained within 3 standard deviations around the arithmetic mean. (Select the correct answer from the choices below.) A. 68.26 B. 95.0 C. 75.00 D. 99.7

Q14

Q14: Match the appropriate inferential statistical test to the provided definitions.

A. Chi-Square Test B. ANOVA C. t-test

1. Used to test independence for more than 2 means (i.e. compares the means of more than 2 groups) Letter: _______ 2. Used to test the independence between 2 or more categorical variables Letter: _______ 3. Used to compare means of 2 groups Letter: _______

Thrombus Event

Did the Patient have a Thrombus Event? Days of Support
no 425
no 886
no 714
no 257
no 1257
no 104
no 176
no 220
no 115
no 727
no 104
no 2210
no 1713
no 210
no 56
no 499
no 469
no 130
no 776
no 837
no 39
no 236
no 622
no 275
no 417
no 255
no 97
no 370
no 17
no 640
no 115
no 34
no 1139
no 627
no 755
no 563
no 871
no 690
no 198
no 25
no 490
no 81
no 171
no 1696
no 1100
no 6
no 184
no 509
no 373
no 413
no 7
no 29
no 701
no 2181
no 143
no 110
no 142
no 25
no 336
no 174
no 713
no 215
no 1085
no 112
no 657
no 344
no 476
no 151
no 139
no 1096
no 924
no 1749
no 945
no 601
no 138
no 330
no 148
no 1707
no 397
no 1546
no 866
no 1044
no 445
no 0
no 258
no 440
no 1560
no 116
no 162
no 613
no 480
no 1341
no 1097
no 317
no 66
no 561
no 831
no 154
no 132
no 672
no 8
no 815
no 12
no 364
no 294
no 168
no 465
no 1209
no 1710
no 376
no 26
no 1603
no 17
no 36
no 418
no 719
no 356
no 1238
no 291
no 99
no 759
no 286
no 184
no 390
no 1151
no 13
no 209
no 553
no 611
no 646
yes 614
yes 876
yes 657
yes 600
yes 692
yes 1139
yes 1151
yes 48
yes 596
yes 343
yes 325
yes 1397
yes 419
yes 504
yes 642
yes 790
yes 921
yes 448
yes 1099
yes 894
yes 651
yes 108
yes 523
yes 930

Tobacco Use

Patient has Ischemic Cardiomyopathy (ICM) or Non-Ischemic Cardiomyopathy (NICM)? Does the Patient have a History of Tobacco Use?
NICM NO
NICM NO
NICM NO
NICM No
NICM YES
NICM YES
NICM NO
NICM NO
NICM YES
NICM YES
NICM NO
NICM NO
NICM YES
NICM YES
NICM NO
NICM YES
NICM YES
NICM NO
NICM NO
NICM NO
NICM NO
NICM NO
NICM YES
NICM NO
NICM NO
NICM YES
NICM NO
NICM NO
NICM YES
NICM YES
NICM YES
NICM NO
NICM YES
NICM YES
NICM YES
NICM NO
NICM YES
NICM NO
NICM NO
NICM NO
NICM NO
NICM YES
NICM YES
NICM YES
NICM NO
NICM YES
NICM YES
NICM NO
NICM NO
NICM NO
NICM YES
NICM NO
NICM NO
NICM NO
NICM YES
NICM YES
NICM NO
NICM YES
NICM NO
NICM YES
NICM NO
NICM YES
NICM YES
NICM YES
NICM NO
NICM YES
NICM NO
NICM NO
NICM NO
ICM YES
ICM NO
ICM YES
ICM NO
ICM YES
ICM NO
ICM NO
ICM YES
ICM NO
ICM NO
ICM YES
ICM Yes
ICM NO
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM NO
ICM NO
ICM NO
ICM NO
ICM YES
ICM YES
ICM NO
ICM NO
ICM NO
ICM NO
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM NO
ICM NO
ICM YES
ICM NO
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM Yes
ICM NO
ICM YES
ICM NO
ICM YES
ICM NO
ICM YES
ICM YES
ICM YES
ICM NO
ICM YES
ICM NO
ICM YES
ICM NO
ICM YES
ICM NO
ICM NO
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM NO
ICM YES
ICM NO
ICM NO
ICM NO
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM YES
ICM NO
ICM YES

Financial Data

Cause for Readmission Length of Stay Cost for Readmission (Direct Cost) Cost for Readmission (Direct & Indirect Cost) Contribution Margin (payments minus Direct Cost) Net Income (payments minus all costs)
Stroke 2 2,918.52 4,662.57 302.48 -1,441.57
Stroke 4 6,126.04 10,283.49 7,659.49 3,502.04
Stroke 21 34,254.54 49,821.55 -34,254.54 -49,821.55
Stroke 4 6,552.89 9,712.34 5,600.18 2,440.73
Stroke 6 7,527.53 13,344.35 2,582.65 -3,234.17
Stroke 6 10,130.00 14,938.41 -4,333.01 -9,141.42
Stroke 4 4,062.03 6,759.87 11,841.31 9,143.47
Stroke 3 9,810.99 16,237.06 6,092.35 -333.72
Stroke 0 7,004.56 10,107.25 -3,816.56 -6,919.25
Stroke 2 3,415.81 6,164.34 4,694.73 1,946.20
Stroke 4 5,714.02 8,542.52 8,012.06 5,183.56
Stroke 4 10,099.63 15,408.73 -1,509.29 -6,818.39
Stroke 8 13,232.88 19,471.54 434.25 -5,804.41
Stroke 13 24,369.46 36,267.13 -10,577.92 -22,475.59
Stroke 1 2,541.71 4,011.66 6,038.03 4,568.08
Stroke 2 3,124.63 4,498.31 1,702.62 328.94
Stroke 9 18,791.70 27,502.88 -8,721.85 -17,433.03
Stroke 10 14,250.70 24,682.84 12,575.80 2,143.66
GI bleed 6 13,644.71 19,962.66 3,710.95 -2,607.00
GI bleed 7 10,641.59 17,457.52 17,331.56 10,515.63
GI bleed 6 19,804.83 32,001.11 12,920.91 724.63
GI bleed 12 19,963.48 32,880.62 6,702.69 -6,214.45
GI bleed 64 129,991.43 193,072.59 109,846.26 46,765.10
GI bleed 6 12,268.38 20,159.23 -3,897.03 -11,787.88
GI bleed 7 16,367.14 26,061.84 8,588.13 -1,106.57
GI bleed 8 21,415.23 34,698.89 4,430.16 -8,853.50
GI bleed 19 87,459.32 123,875.69 -87,459.32 -123,875.69
GI bleed 7 5,195.98 9,438.76 -6.62 -4,249.40
GI bleed 7 10,577.25 17,920.86 -4,310.07 -11,653.68
GI bleed 1 4,461.89 7,489.02 -2,900.72 -5,927.85
GI bleed 7 13,105.81 21,026.30 503.44 -7,417.05
GI bleed 21 32,881.21 52,215.48 -10,518.27 -29,852.54
GI bleed 5 11,913.88 17,580.10 1,504.32 -4,161.90
GI bleed 3 7,219.69 11,569.92 2,439.11 -1,911.12
GI bleed 125 380,925.88 611,084.63 66,334.11 -163,824.64
GI bleed 5 7,812.40 11,141.75 5,854.60 2,525.25
GI bleed 4 11,157.51 16,504.90 -38.51 -5,385.90
GI bleed 13 23,316.11 33,744.85 10,734.89 306.15
GI bleed 2 1,028.09 1,683.89 1,026.25 370.45
GI bleed 14 16,616.67 27,906.64 16,965.33 5,675.36
GI bleed 20 22,514.15 38,089.79 25,095.85 9,520.21
GI bleed 3 7,550.32 10,793.76 6,607.11 3,363.67
GI bleed 6 10,522.42 15,477.25 3,635.01 -1,319.82
GI bleed 3 11,655.19 17,146.59 13,539.07 8,047.67
GI bleed 7 7,753.23 13,323.02 -4,127.58 -9,697.37
GI bleed 6 18,359.35 26,862.81 -11,120.65 -19,624.11
GI bleed 4 7,183.82 10,081.45 -1,344.29 -4,241.92
GI bleed 4 7,641.23 12,393.07 4,799.39 47.55
GI bleed 13 29,042.65 41,740.96 -21,627.09 -34,325.40
GI bleed 7 10,683.13 16,645.19 -3,733.57 -9,695.63
GI bleed 6 20,846.80 33,526.36 -13,560.15 -26,239.71
GI bleed 12 32,297.84 48,622.88 -10,229.69 -26,554.73
GI bleed 3 6,478.88 9,369.63 1,063.85 -1,826.90
GI bleed 6 9,014.08 13,081.15 -1,622.20 -5,689.27
GI bleed 4 7,790.32 10,894.00 -2,666.93 -5,770.61
GI bleed 15 21,518.37 31,594.07 -10,430.36 -20,506.06
GI bleed 4 5,727.10 8,659.04 1,904.49 -1,027.45
GI bleed 4 8,336.49 12,372.10 -944.61 -4,980.22
GI bleed 6 13,228.18 19,526.87 -5,596.59 -11,895.28
GI bleed 5 14,288.42 23,899.36 -7,338.86 -16,949.80
GI bleed 10 16,953.57 26,700.66 -9,666.92 -19,414.01
GI bleed 10 19,820.92 30,975.46 -12,534.27 -23,688.81
GI bleed 18 29,905.40 47,439.19 -8,969.44 -26,503.23
GI bleed 17 65,136.85 99,204.41 -33,408.50 -67,476.06
GI bleed 5 12,756.26 20,926.11 -5,651.15 -13,821.00
GI bleed 7 15,392.46 22,183.58 -6,419.09 -13,210.21
GI bleed 3 4,819.55 7,122.36 2,470.62 167.81
GI bleed 1 4,904.67 7,205.43 2,607.40 306.64
GI bleed 7 13,036.49 19,207.08 -5,715.76 -11,886.35
GI bleed 7 8,101.95 14,204.40 -3,937.79 -10,040.24
GI bleed 5 8,154.63 12,242.43 -1,204.35 -5,292.15
GI bleed 7 18,654.11 26,403.31 -1,487.16 -9,236.36
Other 11 26,185.48 37,791.74 15,709.95 4,103.69
Other 10 43,017.45 63,146.31 -40,499.05 -60,627.91
Other 2 8,450.48 12,147.31 54,390.27 50,693.44
Other 6 11,971.95 17,924.75 18,467.01 12,514.21
Other 25 38,717.19 65,784.58 36,504.06 9,436.67
Other 1 878.17 1,324.07 10,004.39 9,558.49
Other 7 50,819.52 70,275.06 233,448.90 213,993.36
Other 1 1,704.41 2,548.50 1,751.13 907.04
Other 15 14,627.96 25,215.99 -2,120.03 -12,708.06
Other 33 41,395.92 68,132.25 -41,395.92 -68,132.25
Other 4 3,292.14 5,442.01 2,079.62 -70.25
Other 11 10,892.48 17,865.45 1,391.16 -5,581.81
Other 1 2,403.59 3,630.46 564.33 -662.54
Other 2 2,706.58 4,017.51 6,676.69 5,365.76
Other 2 2,124.40 3,148.89 5,950.46 4,925.97
Other 6 7,447.04 11,025.15 -2,273.50 -5,851.61
Other 1 1,009.94 1,627.64 904.76 287.06
Other 0 1,345.97 2,320.24 936.83 -37.44
Other 5 7,251.14 10,580.84 2,369.64 -960.06
Other 4 9,701.59 14,144.58 -574.42 -5,017.41
Other 36 37,843.82 62,280.81 -19,537.49 -43,974.48
Other 19 40,537.88 67,417.61 -3,779.96 -30,659.69
Other 9 10,347.35 15,277.24 -3,464.14 -8,394.03
Other 0 502.81 741.18 -76.38 -314.75
Other 69 553,201.72 777,109.97 -89,298.98 -313,207.23
Other 3 4,522.75 6,531.25 2,774.44 765.94
Other 8 11,245.61 16,724.82 -4,271.35 -9,750.56
Other 7 12,664.94 17,829.47 6,020.54 856.01
Other 38 127,857.56 213,022.78 23,823.15 -61,342.07
Other 1 2,471.98 3,752.89 422.95 -857.96
Other 3 25,101.78 32,932.28 -15,933.98 -23,764.48
Other 4 4,987.47 8,101.97 2,289.03 -825.47
Other 1 1,792.17 2,756.24 -37.36 -1,001.43
Other 4 5,566.23 9,171.45 1,104.52 -2,500.70
Other 2 3,810.49 6,450.39 6,280.71 3,640.81
Other 10 11,077.33 18,923.88 7,549.25 -297.30
Vtach &/or AICD fire 5 8,671.91 13,962.84 9,345.18 4,054.25
Vtach &/or AICD fire 34 39,313.13 65,005.33 36,659.28 10,967.08
Vtach &/or AICD fire 19 25,446.41 43,301.83 -6,082.33 -23,937.75
Vtach &/or AICD fire 49 327,441.59 499,434.53 18,358.68 -153,634.26
Vtach &/or AICD fire 2 2,249.49 4,108.83 2,593.51 734.17
Vtach &/or AICD fire 1 2,755.24 4,091.08 2,742.04 1,406.20
Vtach &/or AICD fire 0 826.74 1,388.61 617.31 55.44
Vtach &/or AICD fire 11 30,122.53 46,206.47 -450.11 -16,534.05
Vtach &/or AICD fire 6 10,842.52 16,233.59 -3,916.62 -9,307.69
Vtach &/or AICD fire 1 1,487.62 2,184.46 4,519.55 3,822.71
Vtach &/or AICD fire 6 19,169.92 27,085.14 -4,839.66 -12,754.88
Vtach &/or AICD fire 7 5,462.37 9,825.48 320.62 -4,042.49
Vtach &/or AICD fire 4 4,256.29 6,303.56 1,322.70 -724.57
Vtach &/or AICD fire 2 1,454.75 2,140.38 -13.82 -699.45
Vtach &/or AICD fire 1 4,834.22 7,740.82 9,552.99 6,646.39
Vtach &/or AICD fire 128 389,334.55 600,278.05 23,539.80 -187,403.70