Question Details

(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 "Test value". 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
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Jan 30, 2021

PRICE: $15

Solution~0001018294.zip (25.37 KB)

Buy this answer for only: $15

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 .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Jan 30, 2021

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now