80.2K

Verified Solution

Link Copied!

$1.$ The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of $2011.$ Please use the attached worksheet to answer the following questions:

a$.$ Use the COUNTIF function to construct a frequency distribution of the item description.

b$.$ Use the Histogram tool to construct the frequency distribution, relative frequency, and the cumulative relative frequency of the units sold $.$

c$.$ Construct cross$-$tabulation of Region, item description, and total revenue per item. Note that revenue is unit price times unit sold. The total revenue per item is the sum of all the revenues of that item. Store and Regional Sales Database

ID Store No$.$ Sales Region Item No$.$ Item Description Unit Price Units Sold Week Ending

$11$ South $200524"$ Monitor $$229\mathrm{.}0028$ October

$21$ South $200524"$ Monitor $$229\mathrm{.}0030$ November

$31$ South $200524"$ Monitor $$229\mathrm{.}009$ December

$41$ South $3006$ Wireless Keyboard $$19\mathrm{.}9530$ October

$51$ South $3006$ Wireless Keyboard $$19\mathrm{.}9535$ November

$61$ South $3006$ Wireless Keyboard $$19\mathrm{.}9539$ December

$71$ South $6050$ PC Mouse $$8\mathrm{.}9528$ October

$81$ South $6050$ PC Mouse $$8\mathrm{.}953$ November

$91$ South $6050$ PC Mouse $$8\mathrm{.}9538$ December

$101$ South $8500$ Laptop $$849\mathrm{.}9525$ October

$111$ South $8500$ Laptop $$849\mathrm{.}9527$ November

$121$ South $8500$ Laptop $$849\mathrm{.}9533$ December

$132$ South $200524"$ Monitor $$229\mathrm{.}008$ October

$142$ South $200524"$ Monitor $$229\mathrm{.}008$ November

$152$ South $200524"$ Monitor $$229\mathrm{.}0010$ December

$162$ South $3006$ Wireless Keyboard $$19\mathrm{.}958$ October

$172$ South $3006$ Wireless Keyboard $$19\mathrm{.}958$ November

$182$ South $3006$ Wireless Keyboard $$19\mathrm{.}958$ December

$192$ South $6050$ PC Mouse $$8\mathrm{.}959$ October

$202$ South $6050$ PC Mouse $$8\mathrm{.}959$ November

$212$ South $6050$ PC Mouse $$8\mathrm{.}958$ December

$222$ South $8500$ Laptop $$849\mathrm{.}9518$ October

$232$ South $8500$ Laptop $$849\mathrm{.}9518$ November

$242$ South $8500$ Laptop $$849\mathrm{.}9520$ December

$253$ South $200524"$ Monitor $$229\mathrm{.}0038$ October

$263$ South $200524"$ Monitor $$229\mathrm{.}0030$ November

$273$ South $200524"$ Monitor $$229\mathrm{.}003$ December

$283$ South $3006$ Wireless Keyboard $$19\mathrm{.}9530$ October

$293$ South $3006$ Wireless Keyboard $$19\mathrm{.}9532$ November

$303$ South $3006$ Wireless Keyboard $$19\mathrm{.}9533$ December

$313$ South $6050$ PC Mouse $$8\mathrm{.}9525$ October

$323$ South $6050$ PC Mouse $$8\mathrm{.}955$ November

$333$ South $6050$ PC Mouse $$8\mathrm{.}9526$ December

$343$ South $8500$ Laptop $$849\mathrm{.}9528$ October

$353$ South $8500$ Laptop $$849\mathrm{.}9527$ November

$363$ South $8500$ Laptop $$849\mathrm{.}9529$ December

$374$ North $200524"$ Monitor $$229\mathrm{.}0018$ October

$384$ North $200524"$ Monitor $$229\mathrm{.}0020$ November

$394$ North $200524"$ Monitor $$229\mathrm{.}004$ December

$404$ North $3006$ Wireless Keyboard $$19\mathrm{.}9512$ October

$414$ North $3006$ Wireless Keyboard $$19\mathrm{.}9524$ November

$424$ North $3006$ Wireless Keyboard $$19\mathrm{.}9536$ December

$434$ North $6050$ PC Mouse $$8\mathrm{.}9529$ October

$444$ North $6050$ PC Mouse $$8\mathrm{.}9511$ November

$454$ North $6050$ PC Mouse $$8\mathrm{.}9538$ December

$464$ North $8500$ Laptop $$849\mathrm{.}9521$ October

$474$ North $8500$ Laptop $$849\mathrm{.}9524$ November

$484$ North $8500$ Laptop $$849\mathrm{.}9530$ December

$495$ North $200524"$ Monitor $$229\mathrm{.}0027$ October

$505$ North $200524"$ Monitor $$229\mathrm{.}0025$ November

$515$ North $200524"$ Monitor $$229\mathrm{.}0023$ December

$525$ North $3006$ Wireless Keyboard $$19\mathrm{.}9580$ October

$535$ North $3006$ Wireless Keyboard $$19\mathrm{.}9582$ November

$545$ North $3006$ Wireless Keyboard $$19\mathrm{.}9575$ December

$555$ North $6050$ PC Mouse $$8\mathrm{.}9565$ October

$565$ North $6050$ PC Mouse $$8\mathrm{.}9524$ November

$575$ North $6050$ PC Mouse $$8\mathrm{.}9555$ December

$585$ North $8500$ Laptop $$849\mathrm{.}9555$ October

$595$ North $8500$ Laptop $$849\mathrm{.}9557$ November

$605$ North $8500$ Laptop $$849\mathrm{.}9547$ December

$616$ East $200524"$ Monitor $$229\mathrm{.}0024$ October

$626$ East $200524"$ Monitor $$229\mathrm{.}0085$ November

$636$ East $200524"$ Monitor $$229\mathrm{.}0056$ December

$646$ East $3006$ Wireless Keyboard $$19\mathrm{.}9552$ October

$656$ East $3006$ Wireless Keyboard $$19\mathrm{.}9558$ November

$666$ East $3006$ Wireless Keyboard $$19\mathrm{.}9569$ December

$676$ East $6050$ PC Mouse $$8\mathrm{.}9535$ October

$686$ East $6050$ PC Mouse $$8\mathrm{.}9539$ November

$696$ East $6050$ PC Mouse $$8\mathrm{.}9544$ December

$706$ East $8500$ Laptop $$849\mathrm{.}9578$ October

$716$ East $8500$ Laptop $$849\mathrm{.}9588$ November

$726$ East $8500$ Laptop $$849\mathrm{.}9599$ December

$737$ East $200524"$ Monitor $$229\mathrm{.}0034$ October

$747$ East $200524"$ Monitor $$229\mathrm{.}0036$ November

$757$ East

Answer & Explanation Solved by verified expert

See Answer