Explore BrainMass
Share

Explore BrainMass

    Excel Cake Mix

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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

    Select the most appropriate hypothesis test described in Sections 4.3 and 4.5 to evaluate the following null hypothesis using this worksheet: There is no difference in mean grams of sugar between name brands and generic brands of packaged cake mixes. (Note: variable Type, 1=brand name, 2=generic; assume normality and equal variances.) The tests in 4.3 and 4.5 are F Test of Equality of Variance, Independent T Test, dependent t test, wilcoxon matched pair signed ranks test, related samples sign test, and mcnemar test.

    Cell A34: Name of most appropriate hypothesis test to evaluate the null hypothesis.

    Cells B35:E35: Enter the following labels: Sample Size, Mean, Standard Deviation, Variance.

    Cells A36:A38: Enter the following labels: Brand-name, Generic, Sample. (Hint: these are the descriptive statistics for each of the two groups that are compared as well as the overall sample descriptive statistics.)

    Cells B36:E38: Enter appropriate formulas to display the required statistics based on adjacent labels.

    Cell B40: Enter the following label: Statistics.

    Cells A41:A47: Enter the following labels: Pooled variance, Mean difference, SE difference, df, appropriate test statistic (equal variances), p-level (2-tailed), appropriate effect size.

    Cells B41:B46: Enter formulas to display the required statistics based on adjacent labels. Format cells to round to two decimal places.

    Cell B48: 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 B50: 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.)

    © BrainMass Inc. brainmass.com October 10, 2019, 8:19 am ad1c9bdddf
    https://brainmass.com/statistics/hypothesis-testing/excel-cake-mix-618839

    Attachments

    Solution Summary

    All computations are provided in the Excel file attached.

    $2.19