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

Related Homework Solutions

Statistics Questions: Families of Distributions
Homework Solution
$44.00
Statistics
Mathematics
Probability
Binomial Distribution
Variance
Mean
Exponential Distribution
Density
Poisson Distribution
Gamma Distribution
Variables
Calculations
Critical Appraisal of The Research Paper
Homework Solution
$20.00
Research Paper
Statistics
Evidence
Treatment
Condition
Supporting The Claim
Studies
Arguments
Experiments
Data Samples
Analysis
Clinical Traits
New Medicine
Applied Statistics Questions
Homework Solution
$75.00
Mathematics
Applied Statistics
Transportation Security Administration
Prohibited Tools
Sharp Objects
Cost
Tickets
Beer
Hot Dogs
Data Manipulation
Frequency Distribution
Cumulative Percentage Distribution
Laser Measurement
Manufacturing Compan
Applied Statistics
Homework Solution
$100.00
Mathematics
Statistics
Social Safety
Finance
Logic Model
Data
Research
Health Clinic
Percentage
Probability
Education
Government
Database
Survey
Sample
School Records
Statistics Questions
Homework Solution
$18.00
Statistics
Mathematics
Random Samples
College Classes
GPA
Mean
Standard Deviation
Null Hypothesis
Alternative Hypothesis
Confidence Intervals
P-Values
Degrees Of Freedom
Functions
Get help from a qualified tutor
Live Chats