logo

QUAN102 - Statistics In Business Assignment

7 Pages1209 Words67 Views
   

Victoria University of Wellington

   

Statistics for Business (QUAN102)

   

Added on  2020-03-02

About This Document

The below document discusses the different concepts of Statistics. The various concepts which have been discussed in this assignment in this are " Mean, median, mode, range, variance and standard deviation separately for every type of business" and "Frequency and relative frequency distributions starting from class 0 to 30".

QUAN102 - Statistics In Business Assignment

   

Victoria University of Wellington

   

Statistics for Business (QUAN102)

   Added on 2020-03-02

ShareRelated Documents
Running Head: STATISTICS 1StatisticsNameUniversity25th August 2017
QUAN102 - Statistics In Business Assignment_1
STATISTICS 2You must use MS Excel for this assignmentTask 1 10 marksThe data for Task 1 in the data file for Assignment represents the starting costs in thousandsof dollars) for different kind of business.1.Find mean, median, mode, range, variance and standard deviation separately for everytype of business (2 marks)SolutionX1X2X3X4X5Mean83.0092.0972.3087.0051.63Median80.0087.0070.0097.5049.00Range105.00120.0090.00115.0090.00Variance1165.171512.69983.791289.11733.05Standard Deviation34.1338.8931.3735.9027.072.For every business type constructa.frequency and relative frequency distributions starting from class 0 to 30 (3 marks)SolutionX1X2X3X4X50-300000631-604343561-904431491-12032251121-15021110151-18001000Total1311101016b.a relative frequency histogram (3 marks)Solution05010015020025000.01Histograms (X2)Unnamed Series 2X2Unnamed Series 6Normal(92.300,40.991)X2Density0204060801001201401601802000Histograms (X1)Unnamed Series 2X1Unnamed Series 6Normal(83.900,33.825)X1Density
QUAN102 - Statistics In Business Assignment_2
STATISTICS 305010015020025000.010.01Histograms (X4)Unnamed Series 2X4Unnamed Series 6Normal(87,35.904)X4Density02040608010012014000.02Histograms (X5)Unnamed Series 2X5Unnamed Series 6Normal(39.100,21.794)X5Density3.Discuss the results obtained in parts 1 and 2 (2 marks)SolutionResults shows that on average X2 has the highest mean costs ($92,090) while X5 hasthe lowest average cost ($51,630). In terms of spreading out of the data, X5 is lessspread out while X2 is more spread out. Frequency distribution shows that the costs are mostly spread out between 31-150thousand of dollars for all the five different types of businesses.4.Test if there significant difference in the starting costs for these types of business. (3marks)SolutionAnova: Single FactorSUMMARYGroupsCountSumAverageVarianceX1131079831165.167X211101392.090911512.691X31072372.3983.7882040608010012014000.01Histograms (X3)Unnamed Series 2X3Unnamed Series 6Normal(72.300,31.365)X3Density
QUAN102 - Statistics In Business Assignment_3

End of preview

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

Related Documents
(Solution) Statistics Assignment
|9
|1228
|303

Assignment on Statistics Of Costing Using MS Excel
|5
|1956
|202

HI6007 Statistics and Research Methods for Business
|10
|1180
|65

Descriptive Statistics Name of the University Author
|11
|1247
|493

Statistics for Business Decisions - PDF
|7
|661
|194

Assignment On Supplementary Work
|8
|532
|17