Reference no: EM133522620

Assignment: Techniques & Interpretation for Statistical Analysis

Length: 1500 words.

Textbook: Ravid, R. (2020). Practical statistics for educators (6th ed.). Rowman & Littlefield Publishers. ISBN: 9781475846836. Read: Chapters 7 & 8.

In the back of the required textbook, you will find some scenarios of testing opportunities. These listed scenarios each differ in the type of situation and variables being collected.

Question A. Now that you have read all three scenarios, you are to select one of the three options and develop a short but informative context for this presented virtual environment. Write about this school site, carefully including within your descriptive writing the necessary problem that is being asked by the introductory scenario that you selected.

Question B. Next, create a database of at least a sample of 30, whose numbers appear to be logical in their development. Create this database using an Excel spreadsheet so it will allow you to run statistical correlational and regression measures once it is created. Place in your paper, a sampling of the type of reported data that you have collected, explaining how it was collected and why the two sets of data may appear to be correlated.

Question C. Describe in the next paragraph the actual statistical measures that you have selected to use to better understand the needed answer. Since this assignment is related to being able to understand and use correlation and regression, be sure to select these along with any other options you want to share.

Question D. Now that you have set up all the necessary background for this scenario, you can run the appropriate correlation and regression statistical measure using an excel spreadsheet.

Question E. Create a report in the form of a table to show what was found when you used the statistical measure with Excel. Remember to look at how to create the proper table using APA guidelines (no vertical lines allowed and very few horizontal).

Question F. Finish this assignment by writing a conclusion to what the table is suggesting. Remember you should not suggest that the one incident caused the other, but only that there is a type of correlation between the listed variables.