•Use the data provided in the attachment. Use the statistical tables given in the appendices of the textbook and a statistical analysis application: a Microsoft® Excel® spreadsheet, Minitab® statistical software, or SPSS™ software. •Prepare and present a 7- to 9-slide (1 point) Microsoft® PowerPoint® presentation to present your findings. Analyze and compare the data sets. Provide descriptive statistics for each group (4 points). Compare the means of the two groups using inferential statistics (4 points). •Incorporate graphs and tables in your presentation (1 point). •Draw a conclusion (1 point). •Follow APA guidelines (0.5 points). •Use proper grammar (0.5 points). •Presentations should be no longer than 15 minutes
Note. As consultants, your Learning Team is expected to prepare and deliver a professional product addressing the client’s needs.
Your final team assignment is a power point presentation in which you analyze and compare data Attached you will find an Excel spreadsheet which contains sample data from six groups Each group represents students and their scores on a final exam Also included: Age Gender Male-1 Female-2
- hours studied
- hours of sleep Final grade
Your assignment is to look for a correlation between age and final grade, gender and final grade, # hours studied and final grade, and # hours of sleep and final grade.
Provide descriptive statistics
What I want to know is if a correlation exists and how strong it is. Where is the greatest correlation.
Compare the final grade means of the two groups
You should present this information in charts and tables.
Compare sample 1 and sample 2.