Question

You are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit. Over the past...

You are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit. Over the past few days, you have noticed an increase in patients admitted with a particular infectious disease. You believe that the ages of these patients play a critical role in the method used to treat the patients. You decide to speak to your manager, and together you work to use statistical analysis to look more closely at the ages of these patients.

The data set consists of 65 patients that have the infectious disease with ages ranging from 41 years of age to 84 years of age for NCLEX Memorial Hospital.

Age
69
41
57
55
45
59
71
71
72
67
60
65
73
72
42
45
65
47
44
51
71
66
84
56
61
59
68
73
50
55
77
57
47
71
58
49
65
60
44
61
57
63
61
60
62
55
66
50
77
66
66
65
57
69
59
70
53
76
74
68
55
61
81
43
67

Continue the hypothesis test based on the claim that the average age of all patients admitted to the hospital with infectious diseases is less than 64 years of age.

Show your results and formulas used for the following calculations:

  • Test Statistic
  • Critical Value
  • P-value

How is this done in EXCEL??

Homework Answers

Answer #1

Solve using Excel functions:

Mean: x = AVERAGE( ) = 61.292

Standard deviation: s = STDEV.S( ) = 10.218

n = 65, μ = 64

Degrees of freedom: df = n-1 = 65-1 = 64

Level of significance = 0.05

H0: μ = 64

H1: μ < 64

Test statistic: t = (x-μ)/(s/n^0.5) = (61.292-64)/(10.218/65^0.5) = -2.137

Critical value (Using Excel function T.INV(probbability, df)) = T.INV(0.05,64) = -1.669

p-value (Using Excel function T.DIST(test statistic, df, cumulative)) = T.DIST(-2.137, 64, TRUE) = 0.018

Since p-value is less than 0.05, we reject the null hypothesis and conclude that μ < 64.

So, average age of all patients admitted to the hospital with infectious diseases is less than 64 years.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit. Over the past...
You are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit. Over the past few days, you have noticed an increase in patients admitted with a particular infectious disease. You believe that the ages of these patients play a critical role in the method used to treat the patients. You decide to speak to your manager, and together you work to use statistical analysis to look more closely at the ages of these patients. You do some research...
Refer to the accompanying data set and construct a 95​% confidence interval estimate of the mean...
Refer to the accompanying data set and construct a 95​% confidence interval estimate of the mean pulse rate of adult​ females; then do the same for adult males. Compare the results. Males    Females 81           82 72           94 52           57 59           66 51           54 62           80 52           77 74           85 51           89 62           57 73           35 61           64 62           87 80           74 80           79 63           62 63           67 97           76 43           60 85           65 72           86 66           85 73           69 72          ...
Use ? to approximate σ. Use a 5% level of significance. Data: 69 62 75 66...
Use ? to approximate σ. Use a 5% level of significance. Data: 69 62 75 66 68 57 61 84 61 77 62 71 68 69 79 76 87 78 73 89 81 73 64 65 73 69 57 79 78 80 79 81 73 74 84 83 82 85 86 77 72 79 59 64 65 82 64 70 83 89 69 73 84 76 79 81 80 74 77 66 68 77 79 78 77
TestScore 53 53 56 56 56 58 58 58 59 59 59 60 60 62 63...
TestScore 53 53 56 56 56 58 58 58 59 59 59 60 60 62 63 63 63 64 65 65 66 67 67 67 67 68 69 69 69 69 71 71 72 72 72 72 73 73 73 73 73 74 75 75 75 76 76 76 76 77 77 77 77 77 78 78 78 79 79 79 79 80 80 80 80 80 80 81 81 81 82 82 83 83 83 83 84 84 84...
Kuya is relocating to China to manage a local branch of world news broadcasting station. He...
Kuya is relocating to China to manage a local branch of world news broadcasting station. He needs to decide on which mobile phone providers he should select based on a sample data of monthly charges from various subscribers. He came to you with the data to determine the provider with the lowest charges, on the average. Which provider would you advise Kuya to select? Mobile Unicom Telecom 62 60 62 55 71 58 69 64 68 58 65 57 56...
Question 1: Table 1 shows the number of customers visited by a salesman over an 80-week...
Question 1: Table 1 shows the number of customers visited by a salesman over an 80-week period. Table 1: Customers Visited Over an 80-Week Period 68 64 75 82 68 60 62 88 76 93 73 79 88 73 60 93 71 59 85 75 61 65 75 87 74 62 95 78 63 72 66 78 82 75 94 77 69 74 68 60 96 78 89 61 75 95 60 79 83 71 79 62 67 97 78...
Test score of 40 students are listed below. Find the percentile for the test score of...
Test score of 40 students are listed below. Find the percentile for the test score of 66. 30 35 43 44 47 48 54 55 56 57 59 62 63 65 66 68 69 69 71 72 72 73 74 76 77 77 78 79 80 81 81 82 83 85 89 92 93 94 97 98
A mathematics achievement test consisting of 100 questions was given to 50 sixth grade students at...
A mathematics achievement test consisting of 100 questions was given to 50 sixth grade students at maple Elementary School. The following data show the number of questions answered correct by each student. 75 48 46 65 71 49 61 51 57 49 84 85 79 85 83 55 69 88 89 55 61 72 64 67 61 77 51 61 68 54 63 94 54 53 71 84 79 75 65 50 45 65 77 71 63 67 57 63...
10 A) What is the best regression to forecast salary? 10 C) Are  all variables statistically significant?...
10 A) What is the best regression to forecast salary? 10 C) Are  all variables statistically significant? Did you drop any Final Math Pre req Hours Work experience 94 92 5 Y 74 90 3 Y 74 87 4 Y 76 84 3 N 66 87 2 N 80 49 4 Y 74 42 3 N 71 61 4 N 84 81 5 N 76 67 5 Y 95 93 4 N 78 56 5 N 71 54 3 Y 82...
The test scores of 40 students are listed below.                           30 35 43 44 47   48   54...
The test scores of 40 students are listed below.                           30 35 43 44 47   48   54   55 56 57                           59 62 63 65 66   68   69   69   71   72 72 73   74   76   77   77   78   79   80   81   81 82 83   85   89   92   93   94   97   98              a)     Find the lower and upper quartiles for the data.              b)     Find the interquartile range.              c)     Draw the box-and-whisker diagram for the data.