Excel Assignment Week 1 Hannah Gothorp

xlsx

School

DeVry University, Keller Graduate School of Management *

*We aren’t endorsed by this school

Course

226

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

2

Uploaded by hbgothorp

Report
HIT 226 Excel Application Activity # 1 - See the syllabus section "Du Patient # Patient age Patient's gender Points allocated Question # 1 57 Male 5 1 2 62 Female 5 2 3 60 Female 10 3 4 57 Female 10 4 5 58 Male 10 5 6 62 Female 10 6 7 61 Male 10 7 8 60 Male 5 8 9 65 Female 5 9 10 59 Female 10 10 11 58 Female 10 11 12 62 Male 10 12 13 67 Male 100 Total points 14 56 Female N 14 Males 6 Females 8 A researcher is testing a new hypertension medication on a group of patients. Use t credit, use the formula functions available in Excel. (Hint: Study descriptive statistics available resources in your course).
ue dates for assignments and exams" Find the following: Calculations Male to female ratio. 3:4 Proportion of females participating in the study. 0.57 Percentage of males participating in the study. 43% Mean/average age of all participants in the study. 60.29 Median age of all participants. 60.00 Mode age for all participants. 62.00 The range among the ages of all participants. 11.00 The second quartile. 60.00 The fourth decile. 59.2 The 75th percentile. 62 The variance among the ages of all participants. 9.91208791208791 The standard deviation for the ages of all participants. 3.14834685384059 the data provided to complete the calculations. For full s explained in your textbook and review other
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

TUT week 12.pdf
Individual homework 3.docx
R-Project.docx
statswork.pdf
week 3 homework on HT and ANOVA.docx
Graded quiz 2.docx
Homework3_ungrouped.doc
Week 6 Knowledge.pdf
Week 6 Test.pdf
Week 5 Knowledge.pdf
Week 4 Test.pdf
Week 7 Knowledge.pdf
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
SEE MORE TEXTBOOKS