[Free Guide 2026] Your boss at RAS Direct has some problems that need to be solved to help with projects they are attempting to start. Your job is to solve the problems and explain the methods to your boss

Your boss at RAS Direct has some problems that need to be solved to help with projects they are attempting to start.

Competency

Apply the normal distribution, standard normal distribution, and central limit theorem.

Project Deliverable tie to Competency 

In module 02, you will summarize graphical and numerical methods to represent quantitative data. This includes utilizing the central limit theorem to calculate probabilities for real-world problems. It will also require you to analyze the standard normal distribution to identify z-values and the area under the curve. You will illustrate how to find probabilities, proportions, and percents by using Excel formulas. You will also demonstrate how to identify the z-score given a probability. These concepts allow you to make predictions and analyze the data provided.

Student Success Criteria

View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane.

Scenario

Your boss at RAS Direct has some problems that need to be solved to help with projects they are attempting to start. Your job is to solve the problems and explain the methods to your boss. The Excel Workbook is provided below.

In your submission, include the Excel formulas to find these calculations. Your boss must know the method so they can include the answers in a presentation they are providing later in the week.

Instructions

The Excel Workbook contains four tabs. The first tab contains instructions. The next three tabs contain several questions for you to answer. Ensure that you are completely answering all questions with explanations, and your work is shown in Excel when needed.

Submission Requirements

You must submit the Workbook with the completed calculations, answers, and analysis.

Step-by-Step Guide to Answering the Assignment

1. Understand the Competency and What Is Being Assessed

This assignment evaluates your ability to:

• Apply the normal distribution

• Use the standard normal distribution (z-scores)

• Apply the Central Limit Theorem (CLT)

• Calculate probabilities, proportions, and percentages

• Use Excel formulas correctly

• Explain methods clearly for non-technical stakeholders (your boss)

👉 Key rule: Every numerical answer must be supported by an Excel formula and a written explanation.

2. Review the Excel Workbook Structure

Your Excel workbook has four tabs:

1. Instructions Tab

   • Read carefully before starting

   • Check for rounding rules, units, or formatting requirements

2. Tabs 2–4 (Problem Tabs)

   • Each tab focuses on:

     • Normal distribution concepts

     • Standard normal (z-scores)

     • Central Limit Theorem applications

👉 Do not delete any cells unless instructed.

3. How to Approach Each Question (Repeat This Process)

For every question, follow this structure:

Step 1: Identify What the Question Is Asking

Determine whether you need to find:

• A probability

• A z-score

• A proportion or percent

• A sample mean probability using CLT

Clearly state this in your explanation.

Step 2: Identify Given Values

From the problem, extract:

• Mean (μ)

• Standard deviation (σ)

• Sample size (n), if given

• Probability or z-score, if provided

Mention these values in your explanation.

Step 3: Apply the Correct Statistical Concept

Explain why you are using that concept.

4. Excel Formulas You Must Use (Critical Section)

Your instructor expects to see formulas, not just answers.

A. Finding Z-Scores

Example:

B. Probability Less Than a Value

C. Probability Greater Than a Value

D. Probability Between Two Values

E. Standard Normal Distribution (Z-table Equivalent)

F. Finding Z-Score Given a Probability

G. Central Limit Theorem – Standard Error

Use this value in place of σ when working with sample means.

5. How to Explain Answers (Very Important)

For every question, include a written explanation like this:

Explanation Template (Use This)

First, I identified the mean and standard deviation provided in the problem. Since the question involves calculating a probability using a normal distribution, I used the appropriate Excel normal distribution function.

When a sample mean was involved, I applied the Central Limit Theorem and calculated the standard error by dividing the standard deviation by the square root of the sample size.

I then used Excel’s NORM.DIST or NORM.S.DIST function to calculate the required probability. This method allows accurate prediction and supports decision-making for the project.

This wording directly satisfies the scenario and competency.

6. Presenting Results for Your Boss

Because your boss will use this in a presentation:

• Clearly label:

  • Z-scores

  • Probabilities

  • Percentages

• Convert probabilities to percentages when helpful:

• Use plain language explanations

• Avoid unnecessary formulas in written explanations (formulas stay in Excel)

7. Final Checklist Before Submission ✅

✔ All questions answered on all three tabs
✔ Excel formulas visible (not hardcoded numbers)
✔ Clear written explanation for each problem
✔ Correct statistical method applied
✔ File saved and submitted as an Excel Workbook

8. Common Mistakes to Avoid 🚫

• Using a calculator instead of Excel formulas

• Forgetting to apply CLT when dealing with sample means

• Not explaining why a method was used

• Submitting screenshots instead of the workbook

• Rounding too early in calculations

9. How This Meets the Competency

This approach demonstrates:

• Correct application of normal and standard normal distributions

• Proper use of Central Limit Theorem

• Accurate probability and z-score calculations

• Professional communication suitable for business decision-making

Need Help With This Assignment?

Use Coupon Code: NEW30 to Get 30% OFF Your First Order

Share on Facebook

Post on X

Follow us

Save

Dan Palmer - About Me

I am a professional nursing assignment expert offering comprehensive academic support to university nursing students across various institutions. My services are designed to help learners manage their workload effectively while maintaining academic excellence. With years of experience in nursing research, case study writing, and evidence-based reporting, I ensure every paper is original, well-researched, and aligned with current academic standards.

My goal is to provide dependable academic assistance that enables students to focus on practical training and career growth.

Contact me today to receive expert guidance and timely, high-quality nursing assignment help tailored to your academic needs.