Question: Please use the Palisade Decision Tools Excel software (as well as step by step) Use Excel's functions (not @RISK) to generate 1000 random numbers from

Please use the Palisade Decision Tools Excel software (as well as step by step)

Use Excel's functions (not @RISK) to generate 1000 random numbers from a normal distribution with mean 100 and standard deviation 10. Then freeze theserandom numbers.

a. Calculate the mean and standard deviation of these random numbers. Are they approximately what you would expect?

b. What fraction of these random numbers are within k standard deviations of the mean? Answer for k = 1; for k = 2; for k = 3. Are the answers close to what they should be (about 68% for k = 1, about95% for k = 2, and over 99% for k = 3)?

c. Make a histogram of the random numbers using about 10 bins of your choice. Does this histogram have approximately the shape you would expect?

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!

PUAD 630 - A NALYTICAL T ECHNIQUES U NIVERSITY OF B ALTIMORE , C OLLEGE OF P UBLIC A FFAIRS S EZGIN AYABAKAN , P H D Assignment 5 Individual or in Pairs Due Date: Dec 07, 2015 at 10:00AM There are...

1. (Excel simulation). Some requirements use Excel Data Analysis Toolpak. First, please complete the simulation setup, then answer the questions. 1) Simulation setup: Column Name Generation guideline...

Read Chapter 6 of the book "How to measure anything". Now, write a letter to Mr. Williams, starting with the following statement: "Mr. Williams, currently you work with categorical risk metrics...

\fThis is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Requirement 1 : The following articles will introduce you to the intersection of big data and the accounting profession. Even if you are working in groups, I expect EVERY STUDENT to read ALL of these...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

London School of Science & Technology Qualification Unit number and title BTEC Level 5 HND Diploma Business UNIT 6: Business Decision Making Student name and ID number Assessor name Al Hassan Barrie...

Scenario: Tom Jones, the CFO for the firm PSUWC Energy, LLC, woke up with a start at 4:00 am on 04/27/2018, due to his phone ringing. It was his senior financial analyst, vacationing in Europe,...

A city ballot includes a local initiative that would legalize gambling. The issue is hotly contested, and two groups decide to conduct polls to predict the outcome. The local newspaper finds that 53%...

Many organizations today are involving lower-level employees in control. Give at least two examples of specific actions that a lower-level worker could take to help his or her organization better...

Ex . 1 4 - 3 1 : flexible budget Variances and Sales Volume Variances

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...