preview

You Are Trying To Set Up Tracking For Sales For A Start Up Company Case Study

Better Essays

Scenario You are trying to set up tracking for sales for a start up company. The company has been operating for about 6 months. • The sales force has been keeping track of their activities in an EXCEL spreadsheet that lists customer name, bid number, date requested, date bid sent to customer, the sales person, and the value of the bid. • The finance person has an EXCEL file where the PO numbers are assigned to completed contracts. This file has customer name, the bid number, the PO number, the date the PO was signed, the value of the PO, and the number of items ordered. • Order fulfillment keeps track of the activity by PO number in their own EXCEL spreadsheet. They are interested in the date they receive an order, the date the …show more content…

The Pareto Chart is also used to display information about attribute data. For numeric and date/time data, the following graphs are most useful: • Scatterplots show the relation between 2 variables. If you have information about attribute variables associated with the numeric data, it can be used as a grouping variable to use color to illustrate groups • Matrix plots provide multiple scatter plots for multiple variables. • o Matrix of plots shows every possible combination of variables up to 20 o Each Y versus each X provides an array of all possible XY combinations (-- removed HTML --) Graphing Data – The Graph Menu • Histograms are used to show the distribution of numeric data. The Graph menu choice allow for the overlay of a continuous probability distribution with the same parameters as the collected data • Dotplots show the distribution of numeric data as well. These make comparisons between groups easier • Stem-and-leaf plots show the distribution of the data like the histogram but also keep the information of the specific data values • Probability Plots can be used to find the percentiles of the data regardless of the distribution. They can also be used to compare distributions for locations of center and variation • Probability Distribution Plots can be used to create diagrams and find/show the area under the curve for 24 different distributions • Boxplots use the 5 number

Get Access