hw8 and task 2

profilepbiner
OutputsfromminitabFittedLinePlotFitRegrModelExcelRegrTool.xlsx
Home>Mathematics homework help>Statistics homework help>hw8 and task 2

Sheet1

OUTPUTS AND OUTPUT OPTIONS FOR REGRESSION ANALYSIS
Comparison between minitab Fitted Line Plot, minitab Fit Regression Model, and EXCEL Regression Data Analysis Tool
minitab Fitted Line Plot minitab Fit Regression Model EXCEL Regression Tool
where to find where to find where to find
MODEL SUMMARY/Regression Statistics
Pearson R, R, or "multiple R" no no ü default
R square ü default ü default (or Results) ü default
Confidence interval for R no no no calculate it yourself, see how to do it in file:
Adj R square ü default ü default (or Results) ü default Manual regression calculation of Motulsky example (ch. 22-23).xls
Standard Error (of the residuals) or S ü default ü default (or Results) ü default (Motulsky shows a confidence interval fo R in table 23.1)
(= root mean square error) (so maybe Graphpad Prism calculates it)
# Observations no no ü default
ANALYSIS OF VARIANCE or ANOVA
Sums of Squares (SS) Regression ü default ü default (or Results) ü default
Residual or Error ü default ü default (or Results) ü default
Total ü default ü default (or Results) ü default
Degrees of Freedom or DF Regression ü default ü default (or Results) ü default
Residual or Error ü default ü default (or Results) ü default
Total ü default ü default (or Results) ü default
Mean Squares (MS) Regression ü default ü default (or Results) ü default
Residual or Error ü default ü default (or Results) ü default
Total ü default ü default (or Results) ü default
F statistic or F ü default ü default (or Results) ü default
p-value or P (or significance) ü default ü default (or Results) ü default
REGRESSION EQUATION ü default ü default (or Results) no
COEFFICIENTS TABLE
Intercept ü default ü default (or Results) ü default
Slope ü default ü default (or Results) ü default
(often named after X variable)
Intercept Standard Error no ü default (or Results) ü default
Slope Standard Error no ü default (or Results) ü default
Intercept t Stat no ü default (or Results) ü default
Slope t Stat no ü default (or Results) ü default
Intercept P-value no ü default (or Results) ü default
Slope P-value no ü default (or Results) ü default
Intercept Lower 95% CI no (but graph has it) no ü default
Slope Lower 95% CI no (but graph has it) no ü default
Intercept Upper 95% CI no (but graph has it) no ü default
Slope Upper 95% CI no (but graph has it) no ü default
RESIDUALS OUTPUT (table with all the numbers)
Residuals ü Storage ü Storage ü default
Predicted Y (or FITS) ü Storage ü Storage ü default
Standard Residuals ü Storage ü Storage ü default
RESIDUAL PLOTS
Normal Probability Plot ü Graphs ü Graphs ü main menu
Residuals vs. x or fitted y ü Graphs ü Graphs ü main menu
Histogram ü Graphs ü Graphs no
Residuals vs. Order (of data collection) ü Graphs ü Graphs no
line fit plot (useless in my view) no no ü main menu, but it's useless
FITTED LINE GRAPH
Scatter plot with fitted line ü default no no use Excel scatter plot instead
Formula of fitted line ü default no no ask to display formula in plot
Confidence interval bands for fitted line ü Options no no
Prediction interval bands for fitted line ü Options no no
green highlights: Very useful options that are unique for Minitab or Excel