A solar panel store manager suspects that his inventory levels of solar panels have been higherthan necessary. Based on the record of the number of solar panels held in inventory each dayduring the last sixty days, the manager came up with the following distribution.# of Solar Panels Frequency151516141710181920The demand for the solar panels follows a normal distribution with u=17 and 6=2. Based on thisinformation,1. Develop a Monte Carlo Simulation model on MS Excel of this situation (send me a copy oftie model.)2. Based on one thousand iterations, should the manager change the inventory policy for thesolar panels? (answer in the available space below.)

Open Microsoft Excel and create a new spreadsheet.Assign "Iteration" to column A, "Demand" to column…

Answered: The demand for the solar panels follows…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

A quality control engineer studied the relationship between years of experience as a system control engineer and the capacity of the engineer to complete within a given time a complex control design including the debugging of all computer programs and control devices. A group of 25 engineers having widely differing amounts of experience (measured in months of experience) was given the same control design project. The results of the study are given in the following table with y 5 1 if the project was successfully completed in the allocated time and y 5 0 if the project was not successfully completed. a. Determine whether experience is associated with the probability of completing the task. b. Compute the probability of successfully completing the task for an engineer having
answer D & E ONLY
How do I graph this?
State University has increased its tuition for in-state and out-of-state students in each of the past 5 years to offset cuts in its budget allocation from the state legislature. The university administration always thought that the number of applications received was independent of tuition; however, drops in applications and enrollments the past 2 years have proved this theory to be wrong. University admissions officials have developed the following relationships between the number of applicants who accept admission and enter State and the cost of tuition per semester (in-state) (out-of-state) The university would like to develop a planning model that will indicate the in-state and out-of-state tuitions, as well as the number of students that could be expected to enroll in the freshman class. The university doesn’t have enough classroom space for more than 1,400 freshmen, and it needs at least 700 freshmen to meet all its class-size x2 = 35,000 - 6t2 x1 = 21,000 - 12t1 (xi) (ti):…
Based on the graph rank the three economic variables listed below from most important to least important.Provide one relevant reason to justify your selection for each of the threepositions.
subject: Quantitative Analysis For Business Please answer both. Use the image for question 10. 10. A hair stylist used market research to learn that members of different age groups have different preferences for positive and negative advertisements. Research participants could mark their preference for only one of the two ads. The positive ad presented a model with attractive hair supported by a message affirming the decision to schedule hair styling services, whereas the negative ad displayed a model with unattractive hair supported by a message describing the need for hair styling services. Results are shown in the table below: What is the probability of a site visitor either preferring negative ads or being a member of age category B? 6% 62% 56% 68% 93% 11. A hair stylist averaged 21 clients per day over the past several months. Typically four of these clients have been male. What is the probability for the total number of female clients the hair stylist can expect…
I have attached the picture for review. Please answer section A, B, C.
Exercise 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…
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…
1. 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…
Q2: Correct answer please in details: Due to population growth in the area, the new Liberty High School has just opened in a local school district. The athletic director at Liberty High is planning the launch of the school's track and field team. The first team practice is scheduled for April 1. The activities, their immediate predecessors, and the activity time estimates (in weeks) are listed in the following table. Time (Weeks) Activity Description ImmediatePredecessor Optimistic Most Probable Pessimistic A Meet with board 1 1 2 B Hire coaches A 4 6 8 C Conduct fundraiser A 2 4 6 D Announce program B, C 1 2 3 E Meet with coaches B 2 3 4 F Order team equipment A 1 2 3 G Register athletes D 1 2 3 H Reserve buses for meets G 1 2 3 I Plan first practice E, H, F 1 1 1 What is the expected project completion time (in weeks)? (Round your answer to two decimal places.) If the athletic director plans to start the project on January 1, calculate the…
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…

SEE MORE QUESTIONS

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS