## Assignment Help for Statistics

What does the overall distribution of the ages of passenger on the titanic look like?

a) Make a histogram of the data using either Minitab or Excel.

b) Obtain the boxplot of the data. Excel does not do this easily so use Minitab.

c) Find the five-number summary, the mean, and the standard deviation of the ages.

You can use either Minitab or Excel but Minitab does this more easily.

d) Use the output to describe the overall pattern of the distribution (use the summary

Question 2: (Minitab or Excel)

Solve problem in the textbook 2.36 p. 102

Question 3: (Minitab or Excel)

Solve problem in the textbook 2.54 p. 108

Question 4: (Minitab or Excel)

Solve problem in the textbook 2.91 p. 126

Minitab Instructions for Assignment # 2

The data file for this lab is attached to the email and named Lab2202-141data.

Recall also that you need to open an MS Word file in which you will be storing your

MINITAB output, graphs, and answers to questions. Save your word file.

Question 1: a), b), and c): We obtain at once histogram, boxplot, and summary statistics

- Choose 'Stat → Basic Statistics → Display Descriptive Statistics'

- Select the age variable for the 'Variables' Box

- Click the ‘Graphs’ dialog box open

- Select ‘Histogram of data’ and ‘Boxplot of data’ and press Enter twice

The output will give you the summary stats (in the session window), histogram, and

boxplot (on separate graph windows). There is no need to edit the graphs. Paste all of this

If you prefer to do this in Excel, Excel has functions for count (N), minimum, maximum,

median, quartiles, average, and standard deviation.

- Choose 'Graph → Scatterplot'

- Click on the ‘Simple’ option

- In the first row of the 'variables' table enter

o the response for the 'Y' variable

o the explanatory variable for the 'X' variable and press Enter

Copy and paste the graph in your Word file. Describe what you see.

To find the correlation coefficient:

- Choose 'Stat → Basic statistics → Correlation'

- Select Life Expectancy and Internet Use for the Variables box

- Deselect the ‘Display P-value’ box and press Enter

The correlation coefficient appears in the Session window.

To obtain the equation of the regression line and to plot it on the scatterplot:

- Choose 'Stat → Regression → Fitted line plot'

- Select the appropriate variable (y) for the 'Response' box and press Tab

- Select the appropriate variable (x) for the 'Predictors' box and press Enter

Paste the graph to your MSWord file. You will note that the equation of the regression

line is printed on the graph, along with the value of R2 (ignore the adjusted R2

of reference, rewrite the equation separately in your word document.

You can also do these steps in Excel. Select your data and go to Insert->scatter and

choose the options with dots but no lines. You can find the correlation by going to

Formulas->More Functions->Statistical->CORREL and a dialog box will appear that will

walk you through the steps.

Question 1: (MINITAB) What does the overall distribution of the ages of passenger on the titanic look

like? a) Make a histogram of the data using either Minitab or Excel. b) Obtain the boxplot of the data.

Excel does not do this easily so use Minitab. c) Find the five-number summary, the mean, and the

standard deviation of the ages. You can use either Minitab or Excel but Minitab does this more easily.

d) Use the output to describe the overall pattern of the distribution (use the summary stats!).

a) Make a histogram of the data using either Minitab or Excel

Histogram of age

120

100

80

60

40

20

0

7260483624120

age

## No Comments