Regression analysis and descriptive Statistics Questions

User Generated

Qbbq

Business Finance

Description

Unformatted Attachment Preview

Topic: Probability a) (5 marks) Describe the classical method determine probability with example. With reference from the Table Summary Table below, discuss the meaning, interpretation and any important implications of the following statistics in column B: Passengers (100,000s) Descriptive statistics B Mean (2 marks) 22.58333333 Standard Error (2 marks) 2.805455544 Median (2 marks) 22 Mode (2 marks) 15 Standard Deviation (2 marks) 9.71838308 1 Sample Variance (2 marks) 94.4469697 Kurtosis (3 marks) 0.723953163 Skewness (3 marks) 0.899057655 Range (2 marks) 34 Minimum (1 marks) 10 2 Maximum (1 marks) 44 Sum (2 marks) 271 Count (2 marks) 12 Question Three (26 marks) (a) What are the purposes of regression analysis? How does it help business? Provide a clear relevant example with an explanation. (b) Explain how a statistical significant relationship may not be practical for a management decision. (5 marks) 3 SUMMARY OUTPUT Regression Statistics Multiple R 0.916665699 R Square 0.840276003 Adjusted R Square 0.824303603 Standard Error 4.073572418 Observations 12 ANOVA df Regression Residual Total 1 10 11 SS MS 872.9767442 872.9767 165.9399225 16.59399 1038.916667 F Significance F 52.608 2.74837E-05 Intercept X Variable 1 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 5.060077519 2.686944916 1.883209 0.089052 -0.926808842 11.04696 -0.926808842 11.04696388 1.593023256 0.219632305 7.253137 2.75E-05 1.103651983 2.082395 1.103651983 2.082394529 RESIDUAL OUTPUT Observation 1 2 3 4 5 6 7 8 9 10 11 12 Predicted Y 16.21124031 8.246124031 14.61821705 11.43217054 27.3624031 28.95542636 30.54844961 24.17635659 27.3624031 36.92054264 28.95542636 16.21124031 Residuals -1.21124031 1.753875969 -1.618217054 3.567829457 -2.362403101 -1.955426357 -6.548449612 -4.176356589 -0.362403101 7.079457364 5.044573643 0.78875969 (2 marks each. Total of 10 marks). With reference from the Table: Summary Output, ABOVE, discuss the meaning, interpretation and any important implications of the following statistics: 1. Multiple R 4 2. R Square 3. Standard Error 4. Observations 5. Significance F 5 Intercept Variable: (2 marks each. Total = 8 marks): discuss the meaning, interpretation and any implications of the following statistics: 6. Intercept Coefficient 7. Standard error 8. t-statistic 9. P-value 6 X Variable: (2 marks each. Total = 8 marks): discuss the meaning, interpretation and any important implications of the following statistics: 10. X Variable Coefficient 7. Standard error 8. t-statistic 7 9. P-value THE END ☺ 8
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Topic: Probability
a) (5 marks)

Describe the classical method determine probability with example.

Classical method of determining probability is based on the concept of a statistical
experiment in which the number of possible outcomes is discrete and each outcome is equally
likely. The probability of each outcome is therefore equal to 1 divided by total number of
outcomes. For example in a fair dice, for one toss, there are six possible outcomes; 1, 2, 3, 4, 5,
and 6.
The probability of each outcome =1/total number of outcomes = 1/6

With reference from the Table Summary Table below, discuss the meaning, interpretation and any
important implications of the following statistics in column B:
Passengers
(100,000s)
Descriptive statistics

B

Values are in (100,000s)

Mean (2 marks)

22.58333333 The mean gives the average of all values for a variable of
interest in a dataset. It is a measure of central tendency
and is an estimator of the expected average value of all
values in a dataset. For example, the mean of 22.583
indicates that the average number of passengers in the
dataset is equal to 22.5833

Standard Error
(2 marks)

2.805455544 The standard error is a measure of variation and
measures the expected accuracy in using the sample
mean as an estimator of population mean.

Median (2 marks)

22

The median is a measure of central tendency and gives
the central value dividing the upper 50% values by
quantity from the lower 50% values. It therefore gives the
central value around which all values of a variable of
interest in a dataset revolve around. For example, the
median value of 22 indicates that the central number of
passengers dividing the largest 50% of values from the
smallest 50% of values for number of passengers is 22
1

Mode (2 marks)

15

The mode gives the number that appears most in the
data set. The mode value is 15. The value indicates that
15 is the number that appears most for the number of
passengers.

Standard Deviation
(2 marks)

9.71838308

The standard deviation gives the average deviation of all
values from the average or mean value. The standard
deviation is 9.718 and indicates that individual passenger
values differ from the mean by an average of 9.7184

Sample Variance
(2 marks)

94.4469697

Variance measures how spread out values are from each
other. It gives the average of the squared distances from
each point to the mean. The value of 94.447 indicates
that values are highly spread out from each other.

Kurtosis
(3 marks)

0.723953163 Kurtosis is a measure of the distribution of a variable of
interest. It is a measure of the peakedness or flatness of a
distribution compared with the normal distribution. The
positive value of 0.7239 indicates that the distribution is
flatter as compared to a normal distribution.

Skewness
(3 marks)

0.899057655 Skewness is a measure of the distribution of a variable of
interest. It is a measure of how skewed data is as
compared to the normal distribution. The positive value
of 0.899 indicates that the distribution is positively
skewed as compared to a normal distribution.

2

Range (2 marks)

34

The range gives the difference between the largest and
smallest value for a variable of interest in a dataset. In
this case, the difference between the largest and smallest
value for the number of passengers is 34.

Minimum (1 marks)

10

Minimum gives the smallest value for a variable of
interest in a dataset. In this case the smallest number of
passengers is 10.

Maximum (1 marks)

44

Maximum gives the smallest value for a variable of
interest in a dataset. In this case the largest number of
passengers is 44.

Sum (2 marks)

271

Sum gives the total of all values for a variable of interest
in a dataset. In this case the total number of passengers is
271.

Count (2 marks)

12

Count gives the number of data points for a given variable
in a dataset. For the dataset, the number of data points in
the variable, number of passengers, is 12.

Question Three (26 marks)
(a) What are the purposes of regression analysis? How does it help business? Provide a clear
relevant example with an explanat...


Anonymous
Great content here. Definitely a returning customer.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Content
Related Tags