Business Statistics Analysis

This statistics assignment analyzes business startup costs and their distribution across different industries. It utilizes frequency distributions, histograms, and ANOVA to compare costs and determine significant differences. The second part focuses on modeling annual sales using a regression analysis in Excel, evaluating model fit (R-squared), testing hypotheses, and interpreting slope coefficients.

STATISTICS
Student Name and Number
[Pick the date]
Task 1
1

(1) The requisite computations are outlined below. It is noteworthy that all the figures
highlighted are in ($ 000’s).
(2) (a) The relevant frequency distribution for the variables of interest is outlined below.
2

(b) The relative frequency histogram as required as pasted below.
3

4

5

(3) Some key observations are outlined below.
 The startup costs for the various businesses do not adhere to a normal distribution.
This is apparent from multiple indicators such as skew being non-zero and also the
non-coincidence of mean and median.
 Further, from the relative frequency histogram, it becomes apparent that the setup
costs are greater than $30,000 for all the businesses except the pet shop.
(4) Hypothesis testing
ANOVA Single factor test
6

Significance level (alpha) = 5%
Value of F statistics = 3.25 and the p value = 0.02
Conclusion:
It can be seen that the corresponding p value is not lower than alpha and thus, reject null
hypothesis and accept alternative hypothesis. Therefore, it can be claimed that for different
businesses, the startup costs are quite different.
TASK 2
(1) Excel Output
7

Regression equation is highlighted below.
(2) The key consideration for determining the model fit would be the extent to which the
dependent variable (in this case annual sales) can be accounted for by the predictor
variables. This is clearly exceptionally high as R2 is 0.9932. Hence, the good fit is
confirmed.
(3) The hypotheses for testing are outlined below.
The applicable regression output from excel has been pasted below.
8

The above output leads to p-value indicated by significance F as 0.000.
Decision: Null Hypothesis Rejection (Reason: p value exceeds α)
Conclusion: One of the dependent variables is significant.
(4) The relevant explanation of slope coefficients is summarized in the table.
(5) The confidence interval limits for the various variables are highlighted below.
(6) The testing of the individual slopes can be carried out as follows.
The table highlights the relevant output in relation of hypothesis testing..
9

(7) The above table indicates that model does not need any change as the variables have
proved their significance based on hypothesis testing.
(8) The regression model to be used is captured by the following equation.
Based on the given values of the various input variables, we get the following.
.
10