Assignment
Module Activity - Using Specialized Statistical Software
1.) Use the data presented in the table below to create a Pie Chart using specialized statistical software.
|
Clinic Admissions by Department
|
|
Department
|
Admissions
|
|
Surgery
|
5,426
|
|
OB
|
2,356
|
|
Peds
|
3,346
|
|
Ortho
|
2,100
|
|
Podiatry
|
575
|
|
Pain
|
1,587
|
|
Sports Med
|
2,634
|
|
Eye
|
1,535
|
|
Total
|
19,559
|
2.) Use the data presented in the table below to create a 2-tier Bar Graphusing specialized statistical software.
|
Department
|
Admissions to Date
|
Prior Admissions to Date
|
|
Surgery
|
5,426
|
6,784
|
|
OB
|
2,356
|
2,487
|
|
Peds
|
3,346
|
3,125
|
|
Ortho
|
2,100
|
1,987
|
|
Podiatry
|
575
|
487
|
|
Pain
|
1,587
|
1,687
|
|
Sports Med
|
2,634
|
2,598
|
|
Eye
|
1,535
|
1,566
|
|
Total
|
19,559
|
20,721
|
3.) Use the data presented in the table below, calculate the Mean, Median, and Standard Deviationusing specialized statistical software.
Inpatient Admissions
|
Inpatient Admissions
|
|
Department
|
Jan-Oct This Year
|
Jan-Oct Last Year
|
|
ICU
|
567
|
565
|
|
CCU
|
484
|
756
|
|
Nursery
|
358
|
487
|
|
Newborn
|
125
|
141
|
|
OB
|
987
|
998
|
|
Gen Surgery
|
787
|
876
|
|
Orthopedics
|
426
|
444
|
|
Peds
|
157
|
175
|
|
Total
|
3,891
|
4,442
|
Graphing Statistics with Specialized Statistical Software
This week you all will download a specialized software (other than Excel). To do this, you will need to download the Word document (see attached) with Each table will have special instructions on what to do in the specialized software.
The intent of this assignment is to provide you with an opportunity to demonstrate that you have a basic understanding of specialized statistical software. In this assignment, you will need to use specialized statistical software to:
Create a Pie Chart
Create a 2-Tier Bar Graph
Calculate Statistics
You can choose which specialized software to use but nothing from Excel.
After you have created the graphs and statistical calculations using the specialized software you have chosen, take a screenshot and paste each into a Word document for submission (3 scenarios). Include an introduction that explains your reason for choosing your particular software and any challenges you faced.
Note: If you're unsure of how to take a screenshot, checkout the take-a-screenshot org website or perform an Internet search using "How do I take a screenshot?" as your search phrase.
Add a short introduction above your screenshots that states which specialized statistical software you decided to use and why you chose it. Also describe any challenges you encountered while completing the assignment and how you handled those challenges.
Lesson Content
Sometimes when it comes to performing statistical data analysis, Excel simply isn't enough. Two examples of specialized statistical software are:
R (open-source software that is available for free download)
SPSS Statistics (software from IBM available with a 14-day free trial)
Learn How to Use Specialized Statistical Software with the Resources Below
Up and Running with R
This training material introduces the R statistical processing language, including how to install R on your computer, read data from SPSS and spreadsheets, and use packages for advanced R functions.
The course continues with examples on how to create charts and plots, check statistical assumptions and the reliability of your data, look for data outliers, and use other data analysis tools. Finally, learn how to get charts and tables out of R and share your results with presentations and web pages.
Up and Running with R on Lynda.com
SPSS Statistics Essentials Training
This training material takes a practical, visual, and non-mathematical approach to the basics of statistical concepts and data analysis in SPSS, the statistical package for business, government, research, and academic organization. From importing spreadsheets to creating regression models to exporting presentation graphics, this course covers all the basics, with an emphasis on clarity, interpretation, communicability, and application.