Question: I have a the excel graph part just having trouble answering the question Case study: You are the owner of Poptastic. For the past few

I have a the excel graph part just having trouble answering the question

Case study: You are the owner of "Poptastic". For the past few years, to help supplement your family's income, you have sold premium, homemade popsicles from your food truck and a few local businesses in Pensacola, FL. You want to take a close look at your monthly popsicle sales from 2024 (in number of popsicles sold): January February March April May June July August September October November December 225 385 430 450 520 740 860 770 600 530 430 340 1. Use Microsoft Excel to create the following visuals for your monthly popsicle sales (be sure to label things where appropriate): Bar graph Line graph Using what you know about the trends and changes in your popsicle sales along with what you have learned about the differences between bar graphs and line graphs, which visual do you feel most clearly communicates your monthly popsicle sales for the year? 2. Use formulas in Microsoft Excel to calculate the following for your monthly popsicle sales (round to two decimal places when necessary): Mean Median Mode 5-Number Summary Range Sample standard deviation Outliers (if any) 3. What is the best measure of central tendency for your monthly popsicles sales, the mean or median? Why? 4. Assume this data set approximately follows a normal distribution. What is the z-score for 800 popsicles?

Using this z-score and the standard normal probability distribution table or calculator you use in ALEKS (OR formulas in Excel), find the probability that you will sell over 800 popsicles in one month. Round to 4 decimal places. How can you use probabilities like this one to help plan your monthly and annual purchases for your business? 5. You are considering hiring some part-time help. Based on a friend's analysis of your business (he is a business consultant), he says it would be best to only hire part-time work for months where monthly popsicle sales were more than 1 standard deviation above the mean. According to his advice, which months should you hire part-time help? Why?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Im having trouble with question 3 part A of the attached file. I know and understand her needs but im not sure if im filling out the table correctly ? Assignment Tier 1 Financial Planning...

i need help from section 3 part A I have already posted this and you asked me to post under advanced option Assignment Tier 1 Financial Planning (Tier1FPPA_AS_v1A3) Page 2 of 92 Student...

Hi I know you opted out of an earlier question. I have several open questions. I really need to get them in. Would you be willing to take any of these questions? I have been waiting for 3 days. I...

Please write the selecting tools and approaches (according to the subject R esearch Method ) for this topic SECOND LANGUAGE ACQUISITION: LEVEL OF INTEREST IN LEARNING MANDARIN CHINESE LANGUAGE AS A...

FIN 300 Final: Moore?s Family Restaurant Case Study Note: All financial data in this case is found in the excel spreadsheet that goes along with this case study. A. Past & Current Operations ?Moore?s...

Due to the changing environment and external triggers, contingency planning is necessary. What qualities make a future issue a ?trigger?? Consider you are on the strategic planning team for a soft...

Assessment Type Essay Purpose The purpose of this assessment is to determine students knowledge on withdrawal management and to identify risks for a person living with a substance use disorder...

***READ THIS FIRST*** I need the questions for Part 1 AND Part 2 answered for this case study. The answers must be well-written, detailed, and must answer each question fully with examples from the...

Hello, I need help with with Return of the Tallahassee Beancounters Case (the 2010 version). The solution and teachers handouts for the 2003 version have already been made available, however it's...

Draw both cis- and trans-i, 4-dimethylcyclohexane in their most stable chair conformations. (a) How many stereo isomers are there of cis-1, 4-dimethylcyclohexane, and how many of trans- 1,...

Your classmate, Laura Elder, is confused about the factors that are included in the annual rate of return technique. What is the formula for this technique?

Which agency is charged with enforcing fair housing laws and holding all parties accountable for compliance with these laws and regulations? Unset starred question Office of Civil Rights Office of...

Oust the Turtle Company has the following balances on December 31, 2020: Cash on hand 4,500.00 Cash in bank A 33,000.00 Cash in bank X 50,000.00 Cash in bank C 822,999.72 Cash on hand includes $ 3....