MAT-144-RS-MA3 Online 2023 5

.xlsx

School

Grand Canyon University *

*We aren’t endorsed by this school

Course

-144

Subject

Statistics

Date

Jan 9, 2024

Type

xlsx

Pages

Uploaded by MegaLightningStingray34

Competency Analysis Name Difference Data Percentiles Empirical Rule Visualization Bin Table Scores Before Tutoring Scores After Tutoring Difference in Scores Written Responses Frequency Distribution

Histogram Mean Difference in Scores

Major Assignment 3 Grading Shee Requirements for full credit You have entered your full name in the field provided. Rachael Gordon All cells are explicitly formatted as Numbers with two decimal places. All cells are explicitly formatted as Numbers with two decimal places. All cells are explicitly formatted as Numbers with two decimal places. All cells are explicitly formatted as Numbers with two decimal places. All cells are explicitly formatted as Numbers with two decimal places. Subtotals All cells are explicitly formatted as directed. (optional for student use) Did you meet the requirements? You have calculated the differences for each test score as (After-Before) using appropriate cell references. You have calculated the mean, median, standard deviation, and range for the before data using Excel functions and appropriate cell references. You have calculated the mean, median, standard deviation, and range for the after data using Excel functions and appropriate cell references. You have calculated the mean, median, standard deviation, and range for the difference in scores data using Excel functions and appropriate cell references. You have calculated the percentiles of the difference in scores using appropriate Excel formulas. You have calculated the upper and lower limits of the difference in scores using appropriate cell references. You have responded to question 5b and have included a discussion of your lower and upper limit from the difference in scores data. Your written responses use complete sentences, proper grammar and punctuation. You have calculated a bin min and max, and bin width using the difference data and appropriate cell references. The Bin Min, Bin Max, and Bin Width are formatted according to the directions. You have calculated lower limits of each class for the frequency distribution using the difference data and appropriate cell references. You have calculated upper limits for each class of the frequency distribution using the difference data and appropriate cell references. You have calculated the midpoint for each class of the frequency distribution using the appropriate cell references. You have calculated the frequency for each class of the frequency distribution using the difference data and appropriate cell references. You have calculated the relative frequency for each class of the frequency distribution using the difference data and appropriate cell references.

The Mean Difference in Scores is formatted according to the directions. Subtotals Totals Percentage Score out of 100 You have calculated the mean difference in scores based on the Frequency Distribution table using an Excel formula with cell references. You have created a histogram reflecting your frequency distribution with appropriate formatting, including bin titles, chart title, and titles for the x and y axes.