Question


    Tutorial

    Category :Math/Stat Homework

    Posted By:AccountingExpert

    Price Offered : $25

    Posting Date : 2014/06/20 02:16

    Due Date : 2014/06/28 09:00

    Answered (1 time)



    Individual Incomes: In this assignment you will analyze income data from the Bureau of Labor Statistics covering over 50,000 randomly selected U.S. households (the same data you used in previous weeks). Generate confidence intervals for earnings, using all observations, as well as separately for the categories men and women, using the observations for those two groups only. Using the mean of all observations as the hypothesized mean to test whether mean earnings of men are equal to the overall mean, and, similarly, whether the mean earnings of women are equal to the overall mean, perform hypothesis tests. Draw conclusions based on your analysis and prepare a business report covering your analysis.

    Open the data in the software and generate confidence intervals and perform hypothesis testing. In Excel the function CONFIDENCE() will produce a confidence interval, and ZTEST() will perform a two-tailed confidence test; optionally, in Minitab (using the 1,000 observation subset of data) Stat > Basic Statistics > 1-Sample Z will generate a confidence interval and perform a hypothesis test, as well as generate graphic displays of the data.
    Organize your software results so that you can prepare the business report.
    Need help? Ask any question in the W3: Case Study Exercise Help forum. This forum is a community learning forum. You are all in this learning experience together. It is important to support each other and problem solve as a community. Jump in the forum and answer a question, offer support, give a suggestion, or further the discussion. 

    Prepare a business report presenting the conclusions of the analysis incorporating software results as evidence.

    Answer
    Submitted by AccountingExpert on 2014/06/20 02:19
    teacher rated 211 times

    Price: $25.00

     

    A++ answer report




    ---- file 1.docx preview (414 words)---

    Solution:Analysis xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx given xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Size1000Confidence xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Half xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx the xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Confidence xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx for xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx of xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Limit41.90Interval xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx mean xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx earning xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx MeanDataSample xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Mean1.192294948Degrees xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Limit31.14We xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx females xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Z xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx is xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx of xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx of xxxxx xxxxx xxxxx xxxxx of xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Mean1.6971Degrees xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx the xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx the xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx the xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx 37.12. xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx positive, xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx than xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx is xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx of xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx

    - - - more text follows - - -


    ---- file 2.xls preview ---

    Sheet1
    t Test for Hypothesis of the Mean
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx

    ---- more text follows ----

    Sheet2
    t Test for Hypothesis of the Mean
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx

    ---- more text follows ----

    Sheet3
    r
    xxx
    xxx
    xxxxx
    xxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxxxx
    xxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxxxx
    xxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx

    ---- more text follows ----

    Sheet4
    Confidence Interval Estimate for the Mean
    xxx
    xxx
    xxxxx
    xxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxxxx
    xxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxxxx
    xxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx

    ---- more text follows ----

    Sheet5
    Confidence Interval Estimate for the Mean
    xxx
    xxx
    xxxxx
    xxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxxxx
    xxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxxxx
    xxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxx
    xxx
    xxx
    xxx
    xxx
    xxx

    ---- more text follows ----

    Sheet6
    AGE
    EDUC
    GENDER
    EARNINGS
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx

    ---- more text follows ----


    - - - more text follows - - -



    Login or Register to buy answer

    Down payment will be adjusted against total price. You can see full view of answer or download document after purchase.

    Social Share