Hello, I just need someone to help me correct a few things in my Excel spreadsheet that has to do with statistics. I am struggling on this. I would like someone to make sure the critical value, margin of error, test statistic and p-value are all correct.

Patient #

Infectious Disease

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Age

70

41

58

58

45

59

71

71

72

67

60

65

73

73

42

45

65

66

44

51

71

66

84

56

61

59

68

73

50

55

77

57

48

71

58

49

65

60

44

61

57

63

61

60

62

*Note: Refer to the Word document in th

Slide 6: Find the following statistical calcu

Age Calculations

Mean

Median

Mode

Midrange

Range

Variance

Standard Deviation

Maximum

Minimum

Slide 8: Construct a 95%

Critical Value

Margin of Error

Lower Limit

Upper Limit

alpha

Sample size

Slide 9, 10, 11: Perform the following hyp

Test Statistic

Critical Value

P-value

Degree of freedom

55

66

50

77

66

69

65

57

69

59

70

53

76

75

68

55

61

81

48

67

59

83

69

68

75

95% confide

70.00

60.00

50.00

40.00

Age

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

30.00

20.00

10.00

0.00

-10.00

120.00

100.00

80.00

Age

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

60.00

40.00

20.00

0.00

Critical Value

efer to the Word document in the deliverable instructions for a breakdown of requirements for each slide.

nd the following statistical calculations. In your PPT, include your interpretation of the calculations and the correct uni

Formulas/Answers

62.47

62.50

59.00

71.00

65.00

66.00

61.00

62.50

43.00

102.19

10.11

84.00

41.00

=AVERAGE(C2:C71)

=MEDIAN(C2:C71)

=MODE.MULT(C2:C71)

=(MAX(C2:C71)+MIN(C2:C71))/2

=MAX(C2:C71)-MIN(C2:C71)

=VAR.S(C2:C71)

=STDEV.S(C2:C71)

=MAX(C2:C71)

=MIN(C2:C71)

onstruct a 95% confidence interval for the population mean ages of the patients. Assume that your data is normally distributed and σ is un

-1.67

-2.01

60.46

64.49

=T.INV(0.05,70)

=G31*(G21/SQRT(G37))

=G7+G35

=G7-G35

0.05

70.00

=(100-95)%

Perform the following hypothesis test based on the claim that the average age of all patients admitted to the hospital with i

-1.27

-1.67

0.11

=T.INV(F36,F46)

69.00

=F37-1

Variance

Observations

Hypothesized Mean Difference

df

t Stat

P(T

Don't use plagiarized sources. Get Your Custom Essay on

STA 3215 Rasmussen University Statistics and Analytics Worksheet

Just from $13/Page

The price is based on these factors:

Academic level

Number of pages

Urgency

Basic features

- Free title page and bibliography
- Unlimited revisions
- Plagiarism-free guarantee
- Money-back guarantee
- 24/7 support

On-demand options

- Writer’s samples
- Part-by-part delivery
- Overnight delivery
- Copies of used sources
- Expert Proofreading

Paper format

- 275 words per page
- 12 pt Arial/Times New Roman
- Double line spacing
- Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Delivering a high-quality product at a reasonable price is not enough anymore.

That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more