a) Use Excel to create two sets of 1000 random numbers: one with an average of about 1 (labeled X) and the other with an average of about 2 (labeled Y). Create a third column which contains X+Y. Find the mean and standard deviation of X+Y and compare to values you'd expect.

b) Repeat part a) in Minitab.

For both a and b, make histograms of X,Y,and X+Y and copy into Word. Make a table of the actual and expected mean and standard deviation of X+Y. Do not submit the actual data.

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

    50% discount

    $15.00 $7.50
    for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Applied Statistics Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Upload a file
    Continue without uploading

    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats