## (solution) Week 6 | Assignment - Goodness-of-Fit hypothesis Tests 1 2 3 4 5

Week 6 | Assignment - Goodness-of-Fit hypothesis Tests

Continue using the Cake Mix Assignment Data workbook.

Use a new Excel workbook file for this assignment.

1. Copy the Assignment Data (i.e., cake mix data) to Sheet 1, cells A1:P32, of a new Excel workbook.
2. Select the most appropriate goodness-of-fit test described in Section 4.2 and evaluate the following null hypothesis using this worksheet: There is no difference in mean grams of sugar of packaged cake mixes and the sugar content of a new cake mix that contains 13 grams of sugar. Assume sugar grams are distributed normally.
3. Cell A34: Enter the name of the most appropriate goodness-of-fit test to evaluate the null hypothesis. (HINT: See textbook Chapter 4.2.)
4. Cell A35: Enter a label that identifies the most appropriate measure of central tendency for the dependent variable, e.g., mean, median, or mode. Cell B35: Enter the formula that displays the measure of central tendency identified in cell A35. Adjust cell format to round to two decimal places. (HINT: The best measure of central tendency to report depends on the variable's scale of measurement.)
5. Cell A36: Enter a label that identifies the most appropriate measure of dispersion for the dependent variable, e.g., standard deviation or range. Cell B36: Enter the formula that displays the most appropriate measure of dispersion identified in cell A36. Adjust cell format to round to two decimal places. (HINT: The best measure of dispersion to report depends on the variable's scale of measurement.)
6. Cell A37: Enter the label "Test value". Cell B37: Enter the test value appropriate for your hypothesis test. (HINT: this value is identified in the null hypothesis.)
7. Cells A38:A41: Enter labels for the appropriate test statistic (e.g., t or chi-square statistic), degrees of freedom (df), p-level (2-tailed), and appropriate measure of effect size, e.g., Cohen's d. Cells B38:B41: Enter appropriate formulas to display statistics that reflect adjacent cell labels. Adjust cell formats of cells B38 and B41 to round to two decimal places.
8. Cell B43: Enter the statistical decision regarding the null hypothesis (i.e., reject or fail to reject the null hypothesis). (NOTE: Use the .05 significance level.)
9. Cell B45: Enter test results using APA style (make sure to include informationally adequate statistics). Use adjacent cells as appropriate. (Note: you will not be able to italicize abbreviations and symbols.) (HINT: follow the example in the textbook for reporting test results for the hypothesis test you conducted. For example, the first goodness-of-fit hypothesis test in the textbook is the one-sample t-test. The textbook gives an example of an APA style write-up for a one-sample t-test at the end of the section on this hypothesis test. If you selected a one-sample t-test, you would follow this example very closely.)
10. Save and submit the Excel file with your last name and week number, e.g., Smith6.xlsx.

Week 6 | Assignment - Goodness-of-Fit

hypothesis Tests

1

2 3

4 5 6

7 Continue using the Cake Mix Assignment Data workbook.

Use a new Excel workbook file for this assignment.

Copy the Assignment Data (i.e., cake mix data) to Sheet 1, cells A1:P32, of a new Excel workbook.

Select the most appropriate goodness­of­fit test described in Section 4.2 and evaluate the following null hypothesis using this worksheet: There is no difference in mean grams of sugar of packaged cake mixes and the sugar content of a new cake mix that contains 13 grams of sugar. Assume sugar grams are distributed normally.

Cell A34: Enter the name of the most appropriate goodness­of­fit test to evaluate the null hypothesis. (HINT: See textbook Chapter 4.2.)

Cell A35: Enter a label that identifies the most appropriate measure of central tendency for the dependent variable, e.g., mean, median, or mode. Cell B35: Enter the formula that displays the measure of central

tendency identified in cell A35. Adjust cell format to round to two decimal places. (HINT: The best measure of central tendency to report

depends on the variable's scale of measurement.)

Cell A36: Enter a label that identifies the most appropriate measure of dispersion for the dependent variable, e.g., standard deviation or range. Cell B36: Enter the formula that displays the most appropriate measure of dispersion identified in cell A36. Adjust cell format to round

to two decimal places. (HINT: The best measure of dispersion to report depends on the variable's scale of measurement.)

Cell A37: Enter the label &quot;Test value&quot;. Cell B37: Enter the test value appropriate for your hypothesis test. (HINT: this value is identified in the null hypothesis.)

Cells A38:A41: Enter labels for the appropriate test statistic (e.g., t or chi­square statistic), degrees of freedom (df), p­level (2­tailed), and appropriate measure of effect size, e.g., Cohen's d. Cells B38:B41: Enter appropriate formulas to display statistics that reflect adjacent cell labels. Adjust cell formats of cells B38 and B41 to round to two decimal places. 8

9 10 Cell B43: Enter the statistical decision regarding the null hypothesis (i.e., reject or fail to reject the null hypothesis). (NOTE: Use the .05 significance level.)

Cell B45: Enter test results using APA style (make sure to include informationally adequate statistics). Use adjacent cells as appropriate.

(Note: you will not be able to italicize abbreviations and symbols.) (HINT: follow the example in the textbook for reporting test results for the hypothesis test you conducted. For example, the first goodness­of­

fit hypothesis test in the textbook is the one­sample t­test. The textbook gives an example of an APA style write­up for a one­sample t­test at the end of the section on this hypothesis test. If you selected a

one­sample t­test, you would follow this example very closely.)

Save and submit the Excel file with your last name and week number, e.g., Smith6.xlsx.

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Jan 30, 2021 Solution~0001018294.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

##### Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .

STATUS

QUALITY

Approved

Jan 30, 2021

EXPERT

Tutor 