The Cabo Fiesta Mexican Restaurant is trying to determine whether sales of its popular Pan Con Mucho Sabor breadsticks are correlated with the sales of margaritas. It has data on sales of bread- stick baskets and margaritas for 25 weeks, shown in the worksheet Prob. 9-20. Plot a scatter diagram and compute the correlation using Excel tools. What do your results indicate?
Inverse Normal Distribution
The method used for finding the corresponding z-critical value in a normal distribution using the known probability is said to be an inverse normal distribution. The inverse normal distribution is a continuous probability distribution with a family of two parameters.
Mean, Median, Mode
It is a descriptive summary of a data set. It can be defined by using some of the measures. The central tendencies do not provide information regarding individual data from the dataset. However, they give a summary of the data set. The central tendency or measure of central tendency is a central or typical value for a probability distribution.
Z-Scores
A z-score is a unit of measurement used in statistics to describe the position of a raw score in terms of its distance from the mean, measured with reference to standard deviation from the mean. Z-scores are useful in statistics because they allow comparison between two scores that belong to different normal distributions.
![### Problem 9-20: Cabo Fiesta Mexican Restaurant
This table showcases weekly data from Cabo Fiesta Mexican Restaurant over a period of 25 weeks. It provides detailed records of breadstick orders and margarita sales.
| Week | Breadstick Orders | Margarita Sales |
|------|-------------------|-----------------|
| 1 | 850 | 1340 |
| 2 | 860 | 1340 |
| 3 | 790 | 1300 |
| 4 | 860 | 1340 |
| 5 | 870 | 1370 |
| 6 | 790 | 1240 |
| 7 | 805 | 1285 |
| 8 | 790 | 1240 |
| 9 | 740 | 1170 |
| 10 | 720 | 1130 |
| 11 | 730 | 1150 |
| 12 | 685 | 1070 |
| 13 | 710 | 1150 |
| 14 | 740 | 1140 |
| 15 | 635 | 1030 |
| 16 | 660 | 990 |
| 17 | 720 | 1210 |
| 18 | 880 | 1370 |
| 19 | 880 | 1400 |
| 20 | 920 | 1370 |
| 21 | 930 | 1410 |
| 22 | 840 | 1240 |
| 23 | 830 | 1260 |
| 24 | 825 | 1235 |
| 25 | 790 | 1260 |
### Analysis
- **Breadstick Orders**: The range of breadstick orders fluctuates, with a minimum of 635 in Week 15 and a maximum of 930 in Week 21.
- **Margarita Sales**: Margarita sales show a range from 990 in Week 16 up to 1410 in Week 21. There is noticeable variation, with certain weeks showing spikes in sales.
### Observations
- The](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd0ed14f9-da8b-48c0-bff9-84c9d9cbf002%2F66bb66f0-c12d-43f0-8039-f7c9b2820b13%2Fdxj2ll_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)