logo

Summary Report on Statistics

Process, organize, present, and summarize data on DeVry admissions for the past semester using Excel and analyze each variable using graphical and numerical techniques.

6 Pages553 Words48 Views
   

Added on  2022-12-27

About This Document

The interpretation of the results obtained through hypothesis testing and confidence interval is presented below. It concludes that there is ample evidence to reflect certain conclusions based on the hypothesis test results. The mean starts for the current semester exceed 41.5 on average for each advisor, the proportion receiving online training is lower than 55%, the mean applications taken from those with no training is less than 155, and the mean time per call exceeds 15 minutes. The confidence intervals for each conclusion are also provided.

Summary Report on Statistics

Process, organize, present, and summarize data on DeVry admissions for the past semester using Excel and analyze each variable using graphical and numerical techniques.

   Added on 2022-12-27

ShareRelated Documents
STATISTICS
STUDENT ID:
[Pick the date]
Summary Report on Statistics_1
A. Summary Report
The interpretation of the results obtained through hypothesis testing and confidence interval is
presented below.
a) From the hypothesis test result, it can be concluded that there is ample evidence to reflect
that the mean starts for the current semester do exceed 41.5 on average for each advisor.
There is a 5% chance that the above conclusion may be false. Further, it can be stated with
95% confidence that the mean starts for the current semester per advisor would lie between
43.52 and 45.15. The above observation also supports the result of the hypothesis test since
the value 41.5 does not appear in the above interval.
b) From the hypothesis test result, it can be concluded that there is ample evidence to reflect
that the proportion receiving online training is lower than 55%. There is a 5% chance that the
above conclusion may be false. Further, it can be stated with 95% confidence that the mean
proportion of population receiving online training would lie between 34.27% and 53.73%.
The above observation also supports the result of the hypothesis test since the value 55%
does not appear in the above interval.
c) From the hypothesis test result, it can be concluded that there is ample evidence to reflect
that the mean applications taken from amongst those with no training would be less than 155.
There is a 5% chance that the above conclusion may be false. Further, it can be stated with
95% confidence that the mean applications selected from the population with no training is
estimated to fall between 68.12 and 74.83. The above observation also supports the result of
the hypothesis test since the value 155 does not appear in the above interval.
d) From the hypothesis test result, it can be concluded that there is ample evidence to reflect
that the mean time per call does exceed 15 minutes. There is a 5% chance that the above
conclusion may be false. Further, it can be stated with 95% confidence that mean time per
call is estimated to fall between 15.02 minutes and 16.06 minutes. The above observation
also supports the result of the hypothesis test since the value 15 does not appear in the above
interval.
Summary Report on Statistics_2
B. Appendix
a) The requisite excel outputs are shown below.
Since one sided p value (0.00)< level of significance (0.05), hence null hypothesis is rejected and
alternative hypothesis is accepted.
b) The requisite excel outputs are shown below.
Summary Report on Statistics_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Statistics of Business & Finance - Calculations and Interpretation
|8
|1191
|326

STATISTICS 8. : STATISTICS 1.ssdfasdfdas
|7
|624
|1

Assignment: The Value of Business Statistics for Students
|4
|601
|13

Business Analytics: Report
|7
|914
|39

Statistics for Business and Financial Economics
|12
|1371
|45

STAT2009 Research Methods in The Social Sciences
|12
|1369
|221