logo

Financial Statistics : Assignment

   

Added on  2020-05-11

20 Pages2460 Words92 Views
Running head: FINANCIAL STATISTICSFinancial StatisticsName of the studentName of the universityAuthor’s note

1FINANCIAL STATISTICSExecutive StatisticsIn the present assignment, we present an investigation into the office supply sales data ofHardware and Garden Supplies. A random sample of 60 supply orders was selected for theanalysis. The analysis shows that most of the orders of Hardware and garden supplies are fromcorporate customers. The maximum priority of the order is high and most of the orders areshipped within 2 days of the order being taken. Most of the customers of the organization arefrom the Eastern Region. Moreover, there is no difference in the shipping costs of the orders having critical andlow priority. In addition, there is also no significant difference in the sales from the eastern andwestern region. Further, from the analysis of the data it was found that it is difficult toapproximate the sales from the order quantity of an order.

2FINANCIAL STATISTICSTable of ContentsIntroduction......................................................................................................................................3Analysis...........................................................................................................................................3Descriptive Statistics....................................................................................................................3Order ID...................................................................................................................................3Order Priority...........................................................................................................................3Order Quantity..........................................................................................................................3Sales..........................................................................................................................................3Ship Mode................................................................................................................................4Shipping Cost...........................................................................................................................4Region......................................................................................................................................4Customer Segment...................................................................................................................4Days to ship..............................................................................................................................4Confidence Interval......................................................................................................................4Hypothesis Testing.......................................................................................................................5Correlation and Regression..........................................................................................................6Conclusion and Limitations.............................................................................................................7Appendices......................................................................................................................................9Descriptive Statistics....................................................................................................................9Confidence Interval....................................................................................................................15Hypothesis Testing.....................................................................................................................17Correlation and Regression........................................................................................................18

3FINANCIAL STATISTICSIntroduction In the present assignment, we analysed data on office supplies. Hardware and GardenSupplies have provided the data. The data contains information on 2002 orders of office supplies.Through random selection process, 60 supply orders were selected and analysed. Theorganization provided information on nine variables of interest. The organization has alsoprovided information on the order id which is an identity variable. The data of office suppliescontains information on order quantity, sales ($) and shipping costs. The analysis of the dataprovides information on the average sales for the home office as well as all the selectedcustomers. We also compare the average sales of all the 2002 customers. Further comparison ofthe average sales from the eastern and western states is also compared. Finally, an investigationis also made on the relation between order quantity and average sales. AnalysisDescriptive StatisticsOrder IDThe variable represents a value through which the order can be tracked. Order PriorityThe variable order priority defines the priority of the order. The analysis of the orderpriority shows that the organization hardware and garden supplies have grouped all the officesupply orders into five order priorities (table 1). The analysis of the sample data shows that thehighest number has a low priority and the lowest number of orders have a low priority. The orderpriority of very number of orders does not have any specific order priority (figure 2). Order QuantityThe average number of items in an order is 24.37 (table 2). The number of items for morethan 50% of the orders is 24. The minimum and maximum number of items in an order is 3 and49 respectively. For more than 50% of the orders the range of the number of items is 24. Thevariation in number of items per order for the sample is 56%. SalesThe average sales volume for an order is $1182.28 (table 2). The sales figures for 50% ofthe orders is below $444.38. The minimum and maximum sales for the orders are $14.76 and

End of preview

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

Related Documents
FIN10002 Financial Statistics Assignment
|19
|2553
|358

FIN10002 Financial Statistics - Assignment
|15
|2418
|256

Assignment Economics: Regression Analysis
|16
|2920
|220

FIN10002 Random Sampling Technique Assignment
|9
|1767
|233

FIN10002 Financial Statistics
|16
|1975
|129

Financial Statistics for Desklib Online Library
|20
|2987
|306