FIN10002 Financial Statistics
16 Pages1975 Words129 Views
Added on 2020-02-24
FIN10002 Financial Statistics
Added on 2020-02-24
ShareRelated Documents
Running head: FINANCEFinanceName of the studentName of the universityAuthor’s note
1FINANCEExecutive StatisticsThe sales data provided by Office sales pty Ltd is analysed herein. The analysis showsthat the sales data have four different priority levels, three shipping modes and four differentconsumer segments. The analysis of the sample data shows that the maximum number of ordershave a critical priority. We find that most of the items are shipped thour regular air and most ofthe items are sent by corporate customers. Moreover most of the items are shipped in two days.The company gives priority to critical items for shipment. The analysis shows that the bulk of thesales is for shippment through truck mode. In addition the relation between order quanity andsales is poor.
2FINANCETable of ContentsIntroduction......................................................................................................................................3Analysis...........................................................................................................................................3Descriptive Statistics....................................................................................................................3Confidence Interval......................................................................................................................4Hypothesis Testing.......................................................................................................................5Correlation and Regression..........................................................................................................5Conclusion and Limitations.............................................................................................................7Appendices......................................................................................................................................8Descriptive Statistics....................................................................................................................8Confidence Interval....................................................................................................................13Hypothesis Testing.....................................................................................................................14Correlation and Regression........................................................................................................15
3FINANCEIntroduction In this assignment we analyse the data of sales of banking. The data has been collected by“Office Supplies Pty Ltd”. The company “Office Supplies Pty Ltd” provided the data pertainingto 2000 orders. For the assignment 60 randomly selected orders were and analysed. There areseven different variables whose information was provided by the organization. The variableorder is contains information of the identity of the order. The data also contains informationabout the priority of the order, the mode of delivery, the customer type. Further information wasalso provided about the number of days required to ship the order. The sales data analyses factorswhich influences the sales of the company. Investigation is also done to check for differences inshipping days based on order priority. We also investigate the relation between average sales ($)value and order quantity. AnalysisDescriptive StatisticsOrder IDThe variable Order ID is used to track the order of the sales. This is an identity variable. Order PriorityThe data for order priority is presented in table 1 (appendix). Critical orders have thehighest frequency count of 18. The lowest frequency count is not specified order category. Thereare 9 not specified orders in the sample data. Order Quantity The data for order quanity is presented in table 2 (appendix). The mean and median orderquantity is 26.15. The histogram for order quantity is presented in figure 3 (appendix). From thehistogram it can be said that the data for order quantity is evenly distributed. The spread of order(coefficient of variation) is 55%.
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Analyzing Orders Data for Desklib Online Librarylg...
|24
|4294
|260
Financial Statistics : Assignmentlg...
|20
|2460
|92
Financial Statistics for Desklib Online Librarylg...
|20
|2987
|306
FIN10002 Financial Statistics Assignmentlg...
|19
|2553
|358
FIN10002 Financial Statistics - Assignmentlg...
|15
|2418
|256
Statistical Influences Made by an Organisationlg...
|14
|2316
|115