Comparison of COVID-19 Hospitalization Data Across US States – A Summary Report.

Project Goals

In the last two weeks, we discussed the importance of summarizing data using descriptive statistics. Based on which attributes of data were considered, different descriptive statistics were implemented to the data using Excel’s Data Analysis Tool Pack to get insights into the issue of interest to help the decision-making process. The main goal of this project consists of using Excel or SPSS software and COVID-19 Hospitalization data to calculate descriptive statistics, compare them across US states, and draft a summary report on the data attributes including central location (i.e. arithmetic mean, median, and mode), dispersion (i.e. range, mean absolute deviation, variance, and standard deviation), relative position (i.e. Five summary measures and Boxplot), and association between variables (Covariance and Correlation Coefficient). Students are expected to compare attributes of COVID-19 data using two states and write their final report which must describe the population of interest to the analysis, the data collection procedure, the implementation of the statistical procedure to calculate or estimate the population parameters, the interpretation of the results, and the policy recommendations.

Learning objective

Upon completing this research project, the student will be able to:

– Collect and use data in the decision-making process;

– Calculate descriptive statistics;

Project Grading/Evaluation

– This project will be graded out of 100 points and will contribute 20% to your midterm grade in this course.

– The key success factor for this project is to use the correct and cleaned data and demonstrate a systematic approach to data analysis by using the appropriate tools.

– This project should be completed in Excel or SPSS software.

– A typed; multiple line-space (at 1.15) paper that contain an introduction, a section describing your methodology, a data analysis section and a conclusion section that summarizes the results of your analysis. The formulas used should be shown in

detail, and the calculations shown clearly. All cited work and source of information must be listed in the reference list.

– You should each keep a log on what you have been assigned to do and what you have accomplished

– The project will be evaluated by me and you will receive a discounted grade if there are significant discrepancies.

– The assessment rubric is attached.

Format

Each project will be 3 pages maximum (appendix not included) and must be written using the following guidelines and contents:

– Title page (Include project title and your name)

– Introduction: Problem of the propose study, purpose and justification of the study

– Methodology

– Data analysis

– Interpretation of results

– Findings and conclusion.

– Appendices: Data, Tables, Figures. Certificate of completion-Statistics 191,

– References

Font must be Time New Roman (or Calibri) and Font size must be 12. The line spacing must be multiple at 1.15. The spacing before must be 6 pts and the spacing after must be 6 pts.

The project must be written using the MLA style.

Comparison of COVID-19 Hospitalization Data Across US States – A Summary Report.