logo

Assignment on Statistics Of Costing Using MS Excel

5 Pages1956 Words202 Views
   

Added on  2020-04-07

Assignment on Statistics Of Costing Using MS Excel

   Added on 2020-04-07

ShareRelated Documents
Running Head: STATISTICS 1StatisticsNameUniversity24th September 2017
Assignment on Statistics Of Costing Using MS Excel_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)Solution4080120More0246Histogram (X2)BinFrequency3570105More012345Histogram (X1)BinFrequency
Assignment on Statistics Of Costing Using MS Excel_2

End of preview

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

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

QUAN102 - Statistics In Business Assignment
|7
|1209
|67

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

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

Business Statistics Assignment PDF - Desklib
|9
|1768
|788

Statistics and Business Decision Making Assignment
|10
|1747
|88