Explore BrainMass
Share

# Statistical report using a Minitab program

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Created descriptive statistics from 2008-2012 UCR data.
- Use the data set provided by clicking the image on the right for the Uniform Crimes Report data. Copy and paste this data into the Minitab software.
- Use this information to create descriptive statistics to analyze the types of crimes that are committed and the variance between crimes from 2008 and 2012.
- Create and recode the variables to produce a table and a chart illustrating the variance between crimes from 2008 and 2012.
- Present the Minitab spreadsheet as a table in a Microsoft Word document; include the tables and graphs you created to support analysis of the data and state conclusions about the variance in the types of violent crimes between 2008-2012.

https://brainmass.com/english-language-and-literature/plays-film-and-media/statistical-report-using-a-minitab-program-603904

#### Solution Preview

I have created table and the pie chart provided through the instructions. I also included a scatterplot for use under the robbery section. It is a simple program to operate. I also began an ...

#### Solution Summary

Report on statistical analysis using the Minitab program to analyze data and analysis of the data using the tables and charts provided.

\$2.19

## Regression Analysis - Statistics and Minitab

Management of a soft-drink bottling company wishes to develop a method for allocating delivery costs to customers. Although part of total cost clearly relates to travel time within a particular outlet, another variable reflects the time required to unload the cases of soft drink at the delivery point. A sample of 20 customers was selected from routes within a particular sales territory and the delivery time (in minutes) and the number of cases delivered were measured and recorded in the data set. Develop a regression model to help allocate delivery costs by predicting unloading time based on the number of cases delivered.

1) Begin with a brief description of the problem in your own words. Prepare a report using headings that reflect the tasks you are asked to complete in (4). You are expected to follow the report format guidelines document provided in D2L. You should cut-and-paste al Minitab output--tabular and/or graphical--that is relevant to your analysis,from Minitab into your document.

4) Use your Minitab software to generate the numerical and graphical output
used in your analysis. The file containing the problem data, <DELIVERY.MTW>, is available to you from the D2L announcement for this assignment. Complete the following tasks and discuss each, excluding (b) which does not require discussion:
-1-
Computer Project #3
a) Set up a scatter diagram.
b) Use Minitab's least squares method to obtain the regression output. Show the entire tabluar output for this problem here (you may wish to copy and paste pieces of it into other sections of your report for discussion) .
c) State the regression equation and interpret (justify if necessary) the values for b0 and b1 as applicable for this problem.

d) State the coefficient of determination r2 and interpret its meaning for this problem.

e) Predict the delivery time with both confidence and prediction intervals for a customer that is receiving 20 cases of soft drink.

f) Would it be apropriate to use this model to predict delivery time for a customer who is receiving 50 cases of soft drink? Explain.

g) Discus evidence of a linearelationship betwen the model variables using both the F-test and t-test statistics. Discus the t-test for the y-intercept. Asume an α = .05
level of significance for al tests.

h) Perform a residual analysis. Using the standardized residuals, generate a histogram, normal probabilty plot, and residuals vs. fits. Discus each in terms of the apropriate asumptions of linear egresion.

i) Summarize your findings above in determining the adequacy of the fit of the model and your confidence in its abilty to alocate delivery costs to customers.

View Full Posting Details