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

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 Microsoft Word. Make a table of the actual and expected mean and standard deviation of X+Y. Do not submit the actual data. Please solve above parts and give me the excel, minitab and word files for the 2 problems


Document Preview:

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 Microsoft Word. Make a table of the actual and expected mean and standard deviation of X+Y. Do not submit the actual data. Please solve above parts and give me the excel, minitab and word files for the 2 problems






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 Microsoft Word. Make a table of the actual and expected mean and standard deviation of X+Y. Do not submit the actual data. Please solve above parts and give me the excel, minitab and word files for the 2 problems
May 26, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here