excel stat- lab 1 PDF

Preview

Summary

stat lab...

Description

Lab 1 Number of Specials Sold

Cost of Each Special

Mean Standard Error Median Mode Standard

19.83333333 1.137736544 19.5 20

Mean Standard Error Median Mode Standard

2.478333333 0.313181701 2.47 2.95

Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count

2.786873995 7.766666667 2.903903185 1.503060852 8 17 25 119 6

Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count

0.767135364 0.588496667 -1.689379705 0.05181192 2.01 1.49 3.5 14.87 6

Procedure 1. I copied the data table into Excel. 2. I computed all values for “specials sold” and then for “cost” using the analysis tool kit. 3. I ended up with two separate tables that showed values for both “specials sold” and “cost.” 4. I copied my tables into a document and summarized my results. Analysis I think the data showed the values accurately and gave us a good idea of how many items are being sold. Based off the data, we sold 119 specials and we made $303 total from all sales. The most popular special sold was the Chicken Littles with 25 sold at $3.50 each. The least popular special sold was the Yummy Burger with 17 sold at $1.99 each. The most expensive item on the menu is the Chicken Littles at $3.50 and the least expensive item on the menu is the Baby

Burger at $1.49. We have a menu that varies slightly in the amount sold and cost. We have a range of 8 for amount sold and $2.01 for cost. This means we have an 8-number difference from the most sold and the least number of specials sold. We also have a $2.01 difference of costs of those specials. We have two items on the menu that sold the same amount, the Huge Burger and the Coney Dog with 20 sales each. We also have two items on the menu that cost the same, the Huge Burger and the Porker Burger cost $2.95 each. The average number of specials sold was 19.8 and the average cost was $2.48. This means that our average special costs around $2.48 and we sell around 19.8 of each special we offer. With that being said, our daily average profit is $294.63. Conclusion The findings from the data did accurately show a good idea of how the restaurant is doing. However, there could have been some errors. We could have miscounted the amount sold or left off any important numbers that could skew our final results. From this lab, I learned how to use Excel and how to compute the different values. I also learned how to analyze values and put them into words....