BUS 210 Homework 3.5 Optional
Please download the Homework 3 5 Excel file from Blackboard/ExPrep. This file contains
all the data required to complete the assignment. Please follow the directions and the specific
steps contained in this document. Note that, in general, cells shaded green require inputs,
calculations, and text answers. Please remember to name all charts.
The total points available is 20.
Problem Histogram:
Using XLSTAT, create histograms of the variables Quantity and Cost Per Order. Place both
histograms on the Problem Histogram worksheet starting in A1. Name the charts Chart_1 and
Chart_2
Problem Scatter Plot:
Using XLSTAT, create a scatter plot of Quantity versus Cost Per Order. Place the scatter plot
on the Problem Scatter Plot worksheet starting in A1. Name the chart Chart_1
Problem Bar:
Using XLSTAT, create a bar chart of Supplier and Item Description. Place the Bar chart on
the Problem Bar worksheet starting in A1. Name the charts Chart_1 and Chart_2
