Financial Analysis of Hardware and Garden Supplies - Assignment

Added on - 21 Apr 2020

  • 15

    pages

  • 2418

    words

  • 17

    views

  • 0

    downloads

Showing pages 1 to 4 of 15 pages
Running Head: FINANCIAL ANALYSISFinancial AnalysisName of the StudentName of the UniversityAuthor Note
FINANCIAL ANALYSIS1Executive SummaryTo conduct this research, data has been collected and supplied by ‘Hardware and GardenSupplies’. From the data set, 60 random samples were selected for this research. Descriptivemeasures of all the 8 variables included in the dataset have been calculated. The confidenceinterval of the sales amount and shipping costs will be calculated. Tests will be conducted toshow whether the price of critical orders is high that the price of low priority orders. Test willalso be done to check the difference in the sales between the Eastern and the Western stated.Finally, regression will be conducted to check the effect of the number of orders on the salesamount.
FINANCIAL ANALYSIS2Table of Contents1.0 Introduction................................................................................................................................32.0 Analysis.....................................................................................................................................32.1 Random Number Selection....................................................................................................32.2 Descriptive Statistics.............................................................................................................32.3 Confidence Intervals..............................................................................................................82.4 Hypothesis Testing................................................................................................................92.5 Correlation and Regression....................................................................................................93.0 Conclusion...............................................................................................................................10Appendices....................................................................................................................................11
FINANCIAL ANALYSIS31.0 IntroductionThe dataset on the office supply sales of the company ‘Hardware and Garden Supplies’consists of information about 2002 orders on nine of the variables – Order ID, Order Priority,Order Quantity, Sales amount, Shipment mode, Shipping Cost, Region, Consumer segment andDays to ship. From the 2002 orders, 60 samples were selected randomly. Descriptive statisticssuch as frequency distribution tables of nominal and ordinal variables and for interval variables,necessary summary statistics will be mentioned along with suitable graphs. The range withinwhich the average sales amount and shipping costs will lie will also be provided. Test will alsobe made to evaluate whether the shipping cost is higher in orders with critical priority. Thedifference between the average sales of the orders in eastern and western states has also to betested. The test will be done using independent sample t-test. In the end, the relationship betweenthe order quantity and sales amount has to be evaluated using regression analysis.2.0 Analysis2.1 Random Number SelectionThe dataset contains 2002 orders. It will be extremely laborious to run analysis on all the2002 orders. Thus, 60 orders have been selected from the 2002 orders to make the analysiseasier. These orders have been selected randomly using uniform random number generation inMS EXCEL. All the analysis will be done on these selected 60 samples. The samples wereselected randomly as the estimates obtained with this method of selection will represent thepopulation most appropriately.
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document