- Details
- Parent Category: Programming Assignments' Solutions

# We Helped With This Excel Programming Homework: Have A Similar One?

Category | Programming |
---|---|

Subject | Excel |

Difficulty | College |

Status | Solved |

More Info | Excel Help Online |

Let us worry about your assignment instead!

- Details
- Parent Category: Programming Assignments' Solutions

SOLVED

Category | Programming |
---|---|

Subject | Excel |

Difficulty | College |

Status | Solved |

More Info | Excel Help Online |

All the details and calculation steps needed to be appeared in Excel sheet.

Part I: The game of Keno: keno is an ancient Chinese game that has become popular in recent years. In
one electronic version of this game, a player selects 20 numbers from the set of numbers I through 100.
The computer then randomly draws another set of 20 numbers from the set I through 100, and the
player is rewarded according to how many of his selected numbers have been matched by the 20
numbers drawn by the computer.
Let X be the number of matches between a player's 20 selected numbers and the 20 numbers drawn by
the computer. Then X may range from 0 (no match) to 20 (all match) and follows a hyper-geometric
probability distribution.
For parts (i) - (ix) below, all cells should contain formulas.
(1)
(ii)
(iii)
(iv)
(v)
(vi)
(vii)
(viii)
(ix)
In Part I worksheet of the Excel workbook provided, construct a tabular probability
distribution for X in column E of the worksheet.
In Part I worksheet of the Excel workbook provided, construct a tabular cumulative
probability distribution for X in column F of the worksheet.
In Part I worksheet of the Excel workbook provided, create a graphical probability
distribution for X.
In Part I worksheet of the Excel workbook provided, create a graphical cumulative
probability distribution for X.
Calculate the theoretical expected value (mean), the theoretical variance, and the
theoretical standard deviation of X in the spaces provided for those quantities. Interpret
those values in your Word report
In column M of the worksheet, use the Excel function "=RAND()" to generate 1000
random values according to the standard uniform probability distribution. Next in column N
of the worksheet, use the Excel "=VLOOKUP()" function along with the available tabular
cumulative distribution of part (ii) to randomly generate 1000 values of X according to the
described Hyper-geometric probability distribution.
Calculate the experimental (simulated) expected value (mean), the experimental variance,
and the experimental standard deviation of X in the spaces provided for those quantities.
Complete the table in columns Q, R, and S of the worksheet. In completing this table, you
should calculate the experimental means successively after n = 20, 40, 60, 80, 100, 200, 300,
400, 500, 600, 700, 800, 900, and 1000 simulations. It is natural that the calculated
experimental means are refreshed after each new operation in the worksheet. For the
Theoretical mean of X in column S, use the fixed value of the theoretical mean calculated in
part (v).
Create a line plot of the Experimental mean values versus the number of simulations (n).
Add the horizontal line plot displaying the theoretical mean of X. Use the f9 function of your
keyboard (Mac: fn+f9) to run several simulations of the successive experimental means.
Interpret your observation in the context of the Law of Large Numbers (as the number of
simulations becomes larger, the experimental values of the means approach to their
theoretical value).

Part 2: Complete this part in the designated Excel worksheet.
(i)
(ii)
(iii)
(iv)
(v)
(vi)
(vii)
A normal population is given in column E of the worksheet. Calculate the mean, the
variance, and the standard deviation of this population in the designated cells.
Construct a Relative Frequency Histogram of the given population. Discuss the shape of the
distribution.
Using the random sampling method described in the Instructor Perspective (or otherwise;
e.g., using the Data Analysis ToolPak), randomly draw 30 samples with each sample
consisting of 30 measurements from this population. These samples will occupy columns N
through AQ.
For each sample, calculate the sample mean, the sample variance, and the sample standard
deviation in the designated cells.
Calculate the average of 30 sample means, the average of 30 sample variances, and the
average of 30 sample standard deviations in the designated cells K2, K3, and K4
respectively.
Compare your results of part (v) above with those obtained for the population in part (i).
Discuss similarities and contrasts in the context of the Central Limit Theorem.
Construct a relative frequency histogram for the 30 sample means obtained from part (v)
above. Comment on the shape of the distribution of the sample means.

Is it free to get my assignment evaluated?

Yes. No hidden fees. You pay for the solution only, and all the explanations about how to run it are included in the price. It takes up to 24 hours to get a quote from an expert. In some cases, we can help you faster if an expert is available, but you should always order in advance to avoid the risks. You can place a new order here.

How much does it cost?

The cost depends on many factors: how far away the deadline is, how hard/big the task is, if it is code only or a report, etc. We try to give rough estimates here, but it is just for orientation (in USD):

Regular homework | $20 - $150 |

Advanced homework | $100 - $300 |

Group project or a report | $200 - $500 |

Mid-term or final project | $200 - $800 |

Live exam help | $100 - $300 |

Full thesis | $1000 - $3000 |

How do I pay?

Credit card or PayPal. You don't need to create/have a Payal account in order to pay by a credit card. Paypal offers you "buyer's protection" in case of any issues.

Why do I need to pay in advance?

We have no way to request money after we send you the solution. PayPal works as a middleman, which protects you in case of any disputes, so you should feel safe paying using PayPal.

Do you do essays?

No, unless it is a data analysis essay or report. This is because essays are very personal and it is easy to see when they are written by another person. This is not the case with math and programming.

Why there are no discounts?

It is because we don't want to lie - in such services no discount can be set in advance because we set the price knowing that there is a discount. For example, if we wanted to ask for $100, we could tell that the price is $200 and because you are special, we can do a 50% discount. It is the way all scam websites operate. We set honest prices instead, so there is no need for fake discounts.

Do you do live tutoring?

No, it is simply not how we operate. How often do you meet a great programmer who is also a great speaker? Rarely. It is why we encourage our experts to write down explanations instead of having a live call. It is often enough to get you started - analyzing and running the solutions is a big part of learning.

What happens if I am not satisfied with the solution?

Another expert will review the task, and if your claim is reasonable - we refund the payment and often block the freelancer from our platform. Because we are so harsh with our experts - the ones working with us are very trustworthy to deliver high-quality assignment solutions on time.