Question

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

Applied Statistics Questions

This is only a preview of the solution. Please use the purchase button to see the entire solution

$15.00

or $1 if you
register a new account!

Assisting Tutor

Related Homework Solutions

Descriptive Statistics
Homework Solution
$13.00
Mathematics
Statistics
Measure Volume
Mass
Samples
Data
Standard Deviation
Density
Percentage Error
Experimental Value
Accepted Value
Applied Statistics
Homework Solution
$25.00
Mathematics
Statistics
SIDS
Mean
Alternative Hypothesis
Level of Significance
Standard Deviation
Birth Weights
Two-Sided Test
Statistics Questions
Homework Solution
$20.00
Mathematics
Applied
Statistics
Volatile
Price
Stock
Month
Percentage
Change
Applied Statistics Questions
Homework Solution
$43.00
Statistics
Mathematics
Research
Study
Score
Two-Tailed Test
Variance
Hypothesis Test
Sample Distribution
Standard Deviation
Report
Sketch
Get help from a qualified tutor
Live Chats