# UP New Column of Data for Annual Sales Worksheet

I’m working on a excel multi-part question and need support to help me learn.

Purpose

This week provides data for your Week 2 Signature paper to senior management. Complete the following descriptive statistics analyses with and in ExcelÂ®.Â

Instructions. Use the Week 1 Pasta’s R Us (find below in Resources) dataset.

Steps

A. Create a New Column of data for Annual Sales (\$â€™000)

1. Calculate Annual Sales (\$â€™1000) by formula: SqFt * Sales/SqFt/1000. Use two decimals

2. Example:Â

Given: Sqft = 2000; Sales/Sqft = 700Â

Annual Sales (\$â€™1000) = 2000*700/1000 = 1400.0 (\$â€™1000).

B. Descriptive Statistics CalculationsÂ

1. Calculate the mean, population standard deviation, skew, five-number summary (min, max, median, quartile 1, quartile 3, and the interquartile range (IQR) for all variables. Use two decimals but three decimals for skew. Refer to Excel Functions on second tab.

2. Show the calculations formulas or Excel Functions that were used.Â

C. Construct a Single Box and Whisker Plot

1. Use the column Annual Sales (\$â€™1000)Â

2. Select all data in the Annual Sales (\$â€™000) column

3. Use Insert > Insert Statistic Chart > Box and WhiskerÂ

4. Finish the chart with a y-axis label

Does the chart look symmetric? Would you prefer the IQR instead of the population standard deviation to describe this variableâ€™s dispersion? Explain? Answer these questions in your Excel sheet.

D. Construct a Single Histogram

1. Use the column Sales/SqFt

2. Select all data in the Sales/SqFt

3. Use Insert > Insert Statistic Chart > HistogramÂ

4. Finish the chart with x- and y-axis labels

Is the distribution symmetric? If not, what is the skew (negative, positive)? Are there any outliers? If yes, which one(s)?Â

What are the SqFt area of the outlier(s)? Is the outlier(s) SqFt smaller or larger than the average restaurant in the database? What can you conclude from this observation? Answer the questions in your Excel sheet.

E. What measure of central tendency (mean, median) is more appropriate to describe Sales/Sqft? Explain? Answer the questions in your Excel sheet.

## Our Prices Start at \$11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!! ## Why US?

##### 100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

##### Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

##### Original Writing

We complete all papers from scratch. You can get a plagiarism report.

##### Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.