![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
expand_more
expand_more
format_list_bulleted
Question
![A solar panel store manager suspects that his inventory levels of solar panels have been higher
than necessary. Based on the record of the number of solar panels held in inventory each day
during the last sixty days, the manager came up with the following distribution.
# of Solar Panels Frequency
15
15
16
14
17
10
18
19
20
The demand for the solar panels follows a normal distribution with u=17 and 6=2. Based on this
information,
1. Develop a Monte Carlo Simulation model on MS Excel of this situation (send me a copy of
tie model.)
2. Based on one thousand iterations, should the manager change the inventory policy for the
solar panels? (answer in the available space below.)](https://content.bartleby.com/qna-images/question/1516f125-856f-4026-8d08-7de3645b541e/5877c9f1-fbb6-4b82-8244-ad341e266a95/gmqmapl_thumbnail.jpeg)
Transcribed Image Text:A solar panel store manager suspects that his inventory levels of solar panels have been higher
than necessary. Based on the record of the number of solar panels held in inventory each day
during the last sixty days, the manager came up with the following distribution.
# of Solar Panels Frequency
15
15
16
14
17
10
18
19
20
The demand for the solar panels follows a normal distribution with u=17 and 6=2. Based on this
information,
1. Develop a Monte Carlo Simulation model on MS Excel of this situation (send me a copy of
tie model.)
2. Based on one thousand iterations, should the manager change the inventory policy for the
solar panels? (answer in the available space below.)
Expert Solution
![Check Mark](/static/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 3 steps
![Blurred answer](/static/blurred-answer.jpg)
Knowledge Booster
Similar questions
- Please view attachemnet and submit answer.arrow_forward9.2arrow_forwardExercise 2. Use the final project data to complete the following questions. Collaborate with your project partners and produce the Excel outputs for the first analysis listed on the project guidelines below. Read and follow the instructions carefully. The Excel outputs such as tables, graphs, summary statistics produced by using Excel. All statistics should not have more than 2 decimal places. All Excel outputs (such as graphs and summary statistics) for each related analysis must be fitted in one sheet. 2. To analyze the total number of items purchased, construct an ungrouped frequency distribution, graph, and find the summary statistics by each type of customer (regular/promotion). Label the graphs completely. Describe the shape of the distribution for each type of customer and discuss similarities or differences by interpreting the graphs and summary statistics. What can you conclude? 3. To analyze customer age, construct a frequency distribution, graph, and find…arrow_forward
- As a sales analyst for the shoe retailer Foot Locker, one of your responsibilities is measuring store productivity and then reporting your conclusion back to management. Foot Locker uses sales per square foot as a measure of store productivity. While preparing your report for the second quarter results (Q2), you are able to determine that annual sales for last year ran at a rate of $406 per square foot. Therefore, $406 per square foot will be your sales estimate for the population of all Foot Locker stores during Q2. For your Q2 Sales Report, you decide to take a random sample of 64 stores. Using annual data from last year, you are able to determine that the standard deviation for sales per square foot for all 3,400 stores was $80. Therefore $80 per square foot will be your population standard deviation when compiling your Q2 report. Management has asked for the probability that your sample mean based on 64 stores is 1) within $15 and 2) within $5 of the population mean…arrow_forward1. Suppose that you estimate a model of house prices to determine the impact of having beach frontage on the value of a house.14 You do some research, and you decide to use the size of the lot instead of the size of the house for a number of theoretical and data availability rea- sons. Your results (standard errors in parentheses) are: PRICE; = 40 + 35.0 LOT¡ – 2.0 AGE; + 10.0 BED; – 4.0 FIRE; (1.0) (5.0) (10.0) (4.0) (10) N = 30 R2 =.63 where: PRICE¡ =the price of the th house (in thousands of dollars) =the size of the lot of the th house (in thousands of square feet) = the age of the th house in years =the number of bedrooms in the th house =a qualitative/dummy variable for a fireplace (1 = yes for the th house) LOT; AGE; BED; FIRE; a. You expect the variables LOT and BED to have positive coefficients. Create and test the appropriate hypotheses to evaluate these expectations at the 5-percent level. b. You expect AGE to have a negative coefficient. Create and test the appropriate…arrow_forward9. Is a Linear Model Appropriate? The number, in thousands, of bacteria in a petri dish is given by the following table. Time is measured in hours. 27This is taken from the Statistical Abstract of the United States and inarrow_forward
- An entrepreneur who owns and operates two businesses (A and B) would like to analyze their profitability. They would like your help in the analysis. They give you the annual net profit (in thousands of $) for each business from 2008-2020. Table 1: Annual Net Profits for Businesses A and B Business Year Profit Business Year Profit 2008 -50 2008 -10 2009 57 2009 30 2010 71 2010 27 2011 64 2011 22 2012 60 2012 21 2013 50 2013 20 A 2014 41 2014 24 2015 59 2015 24 2016 71 2016 32 2017 71 2017 36 2018 74 2018 37 019 81 20 40 2020 97 2020 49 a. Suppose you want to graph the distribution of profits. Explain why using only one stem- plot might not be optimal for the analysis. b. Describe the correct stemplot to use. Generate this stemplot. Explain your steps. What can you say about the distribution from this stemplot? c. When are stemplots useful? And why is that? d. Suppose that instead of having 26 observations you have 200 observations. What graph should you generate? e. What other type of…arrow_forwardPlot the sales revenue figures and appropriate trend line on a graph and identify from this the choice of model for working out the seasonal component. Using the appropriate seasonal model, complete the calculations that are required to produce the required forecasts for quarters 1, 2, 3 and 4 of 2021. On the basis of your analysis explain the recommendation that you would make to ALAW Ltd regarding its future plans.arrow_forwardPison/&user=tmorrison7&key%3DrotNBBCzVIsGRqZV8t.. Previous Problem Problem List Next Problem (1 point) Empathy means being able to understand what others feel. To see how the brain expresses empathy, researchers recruited 16 couples in their midtwenties who were married or had been dating for at least two years. They zapped the man's hand with an electrode while the woman watched, and measured the activity in several parts of the woman's brain that would respond to her own pain. Brain activity was recorded as a fraction of the activity observed when the woman herself was zapped with the electrode. The women also completed a psychological test that measures empathy. Subject 1 3 4 7 8 9 10 11 12 13 14 15 16 Empathy Score 41 48 39 56 64 63 59 53 Brain Activity -0.127 0.3910.02 0.378 0.015 0.404 0.11 0.513 0.149 0.736 0.254 0.573 0.217 0.72 0.355 0.786 47 52 64 73 12 68 28 120 1.2 sub ject Z F20 10,0 120 -8.4 Given that the equation for the regression line is y = 0.00619x +0.00032, what is…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
![Text book image](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
![Text book image](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman