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.
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.
This is only a preview of the solution. Please use the purchase button to see the entire solution