---
## Question Four: MINITAB Regression Output Interpretation
### Hypotheses
- **Null Hypothesis (H₀):** Income has no effect on the dependent variable (β₁ = 0).
- **Alternative Hypothesis (H₁):** Income has a significant effect on the dependent variable (β₁ ≠ 0).
### Interpretation
- **Regression Equation:**
Y^=−4.440+0.9342⋅income
- **Coefficient of income (0.9342):** For every unit increase in income, the dependent variable increases by 0.9342
units.
- **P-value for income (0.000):** Highly significant; reject H₀.
- **R-Sq = 98.8%:** The model explains 98.8% of the variability in the response variable.
- **F-statistic (708.07) and P-value (0.000):** Strong evidence that the regression model is significant.
---
## Question Five: ANOVA
(a) Assumptions of ANOVA
- Independence of observations
- Normality of residuals
- Homogeneity of variances
(b) ANOVA Table Data
(i) Type of ANOVA
Two-way ANOVA without replication** (since each cell has one observation).
(ii) Model
Yij=μ+αi+βj+ϵij
Where:
μ\mu = overall mean
αi\alpha_i = effect of row
βj\beta_j = effect of column (block)
ϵij\epsilon_{ij} = random error
(iii) Hypotheses
H₀ (Rows):** No difference among row means
H₁ (Rows):** At least one row mean differs
H₀ (Blocks):** No difference among block means
H₁ (Blocks):** At least one block mean differs
(iv) Input to MINITAB
- Enter data in columns: one for response, one for row factor, one for block factor.
- Use `Stat > ANOVA > Two-Way` in MINITAB
Question Six: Spreadsheets and Excel
(a) Definition and Advantages
- **Spreadsheet:** A digital worksheet used for organizing, analyzing, and storing data.
- **Advantages:**
- Easy data manipulation
- Built-in formulas and functions
- Visualization tools (charts)
- Automation via macros
- Data filtering and sorting
(b) Excel Code
(i) Sum of Each Row
```excel
=SUM(A1:C1)
=SUM(A2:C2)
=SUM(A3:C3)
```
(ii) Sum of Each Column
```excel
=SUM(A1:A3)
=SUM(B1:B3)
=SUM(C1:C3)
```
### (c) Statistical Analysis
#### Data:
| |A |B |C |
|-------|-----|-----|-----|
| Mean | 1.5 | 2.5 | 3.5 |
| SD | 0.5 | 1.5 | 2.5 |
|N | 10 | 20 | 30 |
#### ANOVA
- **H₀:** All group means are equal
- **H₁:** At least one group mean differs
- Use Excel’s `Data Analysis > ANOVA: Single Factor`
#### t-test (e.g., A vs B)
- **H₀:** Mean of A = Mean of B
- **H₁:** Mean of A ≠ Mean of B
- Use `=[Link](array1, array2, 2, 2)` in Excel
#### P-value
- Calculated from t-test or ANOVA output
- If **P < 0.05**, reject H₀
---
## Question One: MINITAB and ANOVA
### (1a) Two Parts of MINITAB Window
- **Session Window:** Displays textual output (results, commands)
- **Worksheet Window:** Spreadsheet-like interface for data entry
### (1b) ANOVA on Tyre Brands
#### (i) Hypotheses
- **H₀:** All tyre brands have equal mean responses
- **H₁:** At least one brand differs
#### (ii) F-statistic
Calculate using:
\[
F = \frac{\text{Between-group MS}}{\text{Within-group MS}}
\]
Use Excel or MINITAB to compute.
#### (iii) Critical Value
- Use F-table with df₁ = k−1, df₂ = N−k
- At 5% level, compare F-statistic with critical value
#### (iv) Decision
- If F > critical value, reject H₀
- Conclude that tyre brands differ significantly
## Question Two: Regression Analysis
### (a) Variables
- **Dependent:** Y
- **Independent:** X1, X2
### (b) Model
\[
Y = \beta_0 + \beta_1 X_1 + \beta_2 X_2 + \epsilon
\]
### (c) Regression Equation
Use MINITAB to compute:
- Input data in columns
- Use `Stat > Regression > Regression`
### (d) Steps in MINITAB
1. Enter data in worksheet
2. Go to `Stat > Regression > Regression`
3. Select Y as response, X1 and X2 as predictors
4. Click OK to generate output
### (e) Residuals in MINITAB
- After regression, go to `Storage`
- Check “Residuals”
- MINITAB stores residuals in a new column
QUESTION THREE
(a) Define statistical computing and explain its importance
Definition: Statistical computing refers to the use of computers and software tools to perform statistical analysis,
simulations, and data visualization. It involves programming, data manipulation, and applying statistical algorithms to
extract insights from data.
Importance:
• Efficiency: Automates complex calculations and saves time.
• Accuracy: Reduces human error in statistical analysis.
• Advanced Analysis: Enables use of sophisticated models like machine learning and multivariate analysis.
• Visualization: Helps in creating charts and graphs for better interpretation.
• Simulation: Useful for bootstrapping, Monte Carlo methods, and predictive modeling.
(b) Explain the steps involved in using MINITAB to perform regression analysis
Here’s a clear breakdown of how to run regression in MINITAB:
1. Enter Data:
o Open MINITAB.
o Input your dependent variable (Y) and independent variable(s) (X1, X2, etc.) into separate columns in
the worksheet.
2. Access Regression Tool:
o Click on Stat in the top menu.
o Navigate to Regression > Regression > Fit Regression Model.
3. Select Variables:
o Choose your response variable (Y).
o Select your predictor variables (X1, X2, etc.).
4. Configure Options:
o Click Options to set confidence levels or include interaction terms if needed.
5. Run the Analysis:
o Click OK to generate output.
o MINITAB will display coefficients, R-squared values, p-values, and residual plots.
6. Interpret Results:
o Use the output to assess model fit, significance of predictors, and diagnostic plots.
(c) Explain the steps involved in using MINITAB to perform ANOVA
To perform ANOVA in MINITAB:
1. Enter Data:
o Input your response variable in one column.
o Input your factor (grouping variable) in another column.
2. Access ANOVA Tool:
o Go to Stat > ANOVA > One-Way (or Two-Way if applicable).
3. Select Variables:
o Choose the response variable.
o Select the factor variable.
4. Configure Options:
o Set confidence level and choose to store residuals if needed.
5. Run the Analysis:
o Click OK to generate the ANOVA table.
6. Interpret Output:
o Look at the F-statistic and p-value.
o If p < 0.05, reject the null hypothesis (means differ significantly).