Purpose
The purpose of this project is to assess your ability to:
Collect and display data.
Use Excel.
Calculate and interpret expected value.
Calculate the mean, media, and mode of data sets.
Determine whether data sets are normally distributed.
Apply the Central Limit Theorem.
Summarize and report findings.
Overview
This module you will turn in the third part of Project 2. This project consists of three parts.
Project 2-1: Identify the Distribution of a Sample – due in Module 9
Project 2-2: Find A Sampling Distribution of Sample Means – due in Module 10
Project 2-3: Final Submission – due in Module 11
Data that follows a normal distribution pattern is predictable and can be used to draw conclusions. However, many data sets do not follow a normal distribution pattern, and a small sample may not follow the normal distribution even if it comes from a normally distributed population. The Central Limit Theorem tells us that the distribution of sample means will not only be normally distributed, but also, if we have enough samples, the sampling distribution will have a mean that is approximately the same as 𝜇, and a standard deviation that is close to 𝜎𝑛.
To see this, let’s continue the experiment using sets of randomly generated integers.
Action Items
Open your saved Excel file as submitted for Part 2.
Review your gradebook feedback and make any required corrections to Parts 1 or 2.
Complete the tab labeled “Part 3 – Calculate” by using Excel formulas to do the following:Calculate the mean and standard deviation for each of the 4 data sets from Parts 1 and 2.
Calculate the expected standard deviation of the sampling distribution of the sample means.Note, you may either calculate these directly on this tab using cell references, or calculate these using formulas on your original sheets and copy/paste the values into the designated area of the calculation sheet.
Explain how your graphs tables and calculations of the mean and standard deviations relate to the Central Limit Theorem.
View the Project 2 Final Report Example.Download Project 2 Final Report Example.
Download and complete the Probability Project 2-3 – Final Report.Download Probability Project 2-3 – Final Report.
Submit the completed first draft of your assignment. Your work will automatically be checked by Turnitin. Access your Turnitin report by reviewing your Submission Details for this assignment. Revise your work as needed based on the feedback. By the due date indicated, re-submit the final version of your work containing your Final Report and the completed Excel file containing your data and graphs. Note: These items should be submitted at the same time. (If they are submitted separately, any subsequent uploads may override the first submission.)
Rubric
Project 2
Project 2
CriteriaRatingsPts
This criterion is linked to a Learning OutcomePart 1: Random generation of 100 integersGenerate 100 integers randomly using =INT(RAND()*(10)).
Count the frequencies using =countif( and verify the frequency table.
Create a table consisting of expected frequencies and sample(actual) frequencies.
Create a bar chart of the actual frequencies.
Create the expected frequencies (uniform) graph.
5 to >4.0 ptsOne hundred integers were randomly generated correctly using formulas in Excel. The frequencies of each integer (both expected and actual (sample)) are correctly represented in the frequency table. The bar charts of frequencies (both expected and actual (sample)) are accurate. The bar charts have an appropriate title and the axis labels and the x-axis are correct. Improvements were made based on feedback, if applicable.
4 to >2.0 ptsOne hundred (or fewer) integers were randomly generated using formulas in Excel. The frequencies of each integer may not be correctly represented in the frequency table. The bar chart of frequencies may not be accurate. The bar chart may contain errors within the title, axis labels and/or the x-axis. The expected (uniform) bar chart may contain errors. Some improvements may have been made based on feedback.
2 to >0 ptsNo integers were randomly generated or there are major errors in the generation affecting the bar chart and frequency tables. The bar chart, the expected (uniform) graph or frequency table may be missing. Little to no improvements were made based on feedback.
5 pts
This criterion is linked to a Learning OutcomePart 1: Random generation of 1000 integersGenerate 100 integers randomly using =INT(RAND()*(10)).
Count the frequencies using =countif( and verify the frequency table.
Create a bar chart of the actual frequencies.
Create the expected uniform graph.
4 to >3.0 ptsOne thousand integers were randomly generated correctly using formulas in Excel. The frequencies of each integer (both expected and actual (sample)) are correctly represented in the frequency table. The bar charts of frequencies (both expected and actual (sample)) are accurate. The bar charts have an appropriate title and the axis labels and the x-axis are correct. Improvements were made based on feedback, if applicable.
3 to >1.0 ptsOne thousand (or fewer) integers were randomly generated using formulas in Excel. The frequencies of each integer may not be correctly represented in the frequency table. The bar chart of frequencies may not be accurate. The bar chart may contain errors within the title, axis labels and/or the x-axis. Some improvements may have been made based on feedback.
1 to >0 ptsNo integers were randomly generated or there are major errors in the generation affecting the bar chart and frequency tables. The bar chart or frequency table may be missing. Little to no improvements were made based on feedback.
4 pts
This criterion is linked to a Learning OutcomePart 1: AnalysesWrite two paragraphs comparing
the expected uniform graph to the bar chart of frequencies (n=100) and comparing the graphs of n=1000 to the graphs of n=100.
5 to >4.0 ptsThe analysis for the n=100 case is thorough and accurate. It compares and contrasts the expected uniform graph with the bar chart of actual frequencies. The analysis addresses if the same indicates a uniform distribution. The analysis for n=1000 compares and contrasts the graphs of both cases (n=100 & n=1000). Two additional observations are made. Improvements were made based on feedback, if applicable.
4 to >2.0 ptsThe analysis for both cases is present. There are some errors in the comparisons. Some improvements may have been made based on feedback.
2 to >0 ptsThere are no analysis paragraphs, or one of them is missing. If both are present, there are major errors in both of them. Little to no improvements were made based on feedback.
5 pts
This criterion is linked to a Learning OutcomePart 2: Distribution of Sample Mean n=4Create a data set consisting of 250 samples of size n=4.
Calculate the mean of each sample set of 4 values by using =average(.
Verify the counts in the frequency table by using =countif.
4 to >3.0 ptsThe data set is correct. The mean is correct for each sample set. The frequency table was verified. Improvements were made based on feedback, if applicable.
3 to >1.0 ptsThe data set and means are present, but there are errors with some of them. The frequency table may not have been verified. Some improvements may have been made based on feedback.
1 to >0 ptsThe data set was not created, the means were not calculated, nor was the frequency table verified. If the required parts are present, they contain major errors. Little to no improvements were made based on feedback.
4 pts
This criterion is linked to a Learning OutcomePart 2: Distribution of Sample Mean n=16Create a data set consisting of 1000 samples of size n=16.
Calculate the mean of each sample set of 16 values by using =average(.
Verify the counts in the frequency table by using =countif.
4 to >3.0 ptsThe data set is correct. The mean is correct for each sample set. The frequency table was verified. Improvements were made based on feedback, if applicable.
3 to >1.0 ptsThe data set and means are present, but there are errors with some of them. The frequency table may not have been verified. Some improvements may have been made based on feedback.
1 to >0 ptsThe data set was not created, the means were not calculated, nor was the frequency table verified. If the required parts are present, they contain major errors. Little to no improvements were made based on feedback.
4 pts
This criterion is linked to a Learning OutcomePart 2: Analyses of the DistributionsWrite two paragraphs.
For n=4: compare the graph to previous distributions using at least two observations.
For n= 16: compare the graph to previous distributions using at least two additional observations.
4 to >3.0 ptsMeets Expectations
The analyses for both distributions contain the appropriate comparisons including observations. The information is correct and concise. Improvements were made based on feedback, if applicable.
3 to >1.0 ptsThe analysis for both cases is present. There are some errors in the comparisons. Some improvements may have been made based on feedback.
1 to >0 ptsThere are no analysis paragraphs, or one of them is missing. If both are present, there are major errors in both of them. Little to no improvements were made based on feedback.
4 pts
This criterion is linked to a Learning OutcomePart 3: Mean and Standard DeviationCalculate the mean and standard deviation for of the four data sets in Parts 1 and 2.
6 to >5.0 ptsThe means and standard deviations are all calculated and are correct.
5 to >1.0 ptsThe means and standard deviations are all calculated, but contain some errors.
1 to >0 ptsThe means and standard deviations are not calculated, or if they are there are major errors.
6 pts
This criterion is linked to a Learning OutcomePart 3: Expected Standard DeviationCalculate the expected standard deviation of the sampling distribution of the sample means.
3 to >2.0 ptsThe expected standard deviation of the sampling distribution of the sample means is calculated and is correct.
2 to >1.0 ptsThe expected standard deviation of the sampling distribution of the sample means is calculated but is incorrect.
1 to >0 ptsThe expected standard deviation of the sampling distribution of the sample means is not calculated.
3 pts
This criterion is linked to a Learning OutcomePart 3: AnalysisExplain how the graphs, tables and calculations of the mean and standard deviations relate to the Central Limit Theorem.
5 to >4.0 ptsThe analysis includes an in-depth explanation of how the findings related to the Central Limit Theorem. The analysis is thorough and succinct.
4 to >2.0 ptsThe analysis is included, but does not clearly relate the findings to the Central Limit Theorem. The analysis is not thorough and succinct.
2 to >0 ptsThe analysis is not included or if it is, it contains major gaps.
5 pts
This criterion is linked to a Learning OutcomePart 4: IntroductionWrite a brief overview of the purpose of this experiment and what the reader should expect to learn from this report.
3 to >2.0 ptsAn introduction is included. It describes the project and what a reader can expect to learn.
2 to >1.0 ptsAn introduction is included but it does not describe the project or does not describe what a reader can expect to learn.
1 to >0 ptsAn introduction is not included or if included, it contains major gaps.
3 pts
This criterion is linked to a Learning OutcomePart 4: Excel WorkbookFile is complete and submitted.
2 ptsThe Excel file is complete and contains all of the correct information.
1 ptsThe Excel file may not may not be complete or may be complete but has inaccuracies.
0 ptsThe Excel file was not submitted.
2 pts
This criterion is linked to a Learning OutcomePart 4: Graphs and TablesInclude copies of all tables and charts in the report. See the sample report for reference.
2 ptsAll tables and charts are included in the report.
1 ptsSome tables and charts are missing.
0 ptsThe tables and charts were not included in the report.
2 pts
This criterion is linked to a Learning OutcomePart 4: Mechanics
3 to >2.0 ptsBoth report and Excel workbook submitted. Report contains no grammatical or formatting errors.
2 to >1.0 ptsEither report or Excel workbook not submitted. Report contains some grammatical or formatting errors.
1 to >0 ptsReport and/or Excel workbook not submitted. Report contains major grammatical or formatting errors.
3 pts
Total Points: 50
attatched is a sample of what it should look like and also a outline to add answers. thanks so much in advance
Category: Mathematics
-
“Exploring Data Distributions and the Central Limit Theorem: An Excel Project” “Analyzing Randomly Generated Integers and Sample Mean Distributions in Excel” “Analyzing Distributions and the Central Limit Theorem: A Statistical Report” “Analyzing Sales Data Using Excel: A Comprehensive Report”
-
“Mastering Geometry: A Comprehensive Study of Red Comet’s 6 Sections”
Red Comet geometry 6 sections with 15 sub-sections 5 of those sections being lessons and the rest being assignments and 1 end-of-section test. I will need all assignments and tests/quizzes to be completed passing with a B by may
-
Title: “Excel Functions and Matrix Operations Assignment”
What you will be turning in:
1.) Excel sheet with part 1 (Graded on using Excel functions)
2.) Excel sheet with part 2 (Graded on using Excel functions and equations)
3.) Matrix screenshot for part 3a.
4.) Matrix screenshot for part 3b plus an answer the probability question.
5.) Matrix screenshot of original 4 by 4 matrix
6.) Matrix screenshot after RREF has been performed plus the answer to the question. -
“Analyzing Data with Measurement and Statistical Packages: A Comprehensive Exam”
The files you need to complete the assignment are attached below. It requires you to use measurement and statistical packages (e.g., SPSS, GENOVA, and/or calculator) to complete the exam.
-
“Exploring the Mathematical Relationships between Musical Intervals and Tuning Systems: A Study of Dissonance and Consonance”
This is a Maths Exploration. There is a stict guideline which we have to follow (see below). We choose our own research question, which in my case is: “Mathematically determining the ratios of musical inetrvals in different tuning systems and their levels of dissonance and consonance.” Since there is a personal background part, I have already written that part. I have my started draft as .docx file, as well as the guidelines, some background research and an example of what the paper should look like.
-
Urgent Help Needed: Math 146 College Class Test on Pearson
Hello the test is through Pearson I will provide the login once I hire you. It is 10 questions and once you enter the test you can exit it or else it will fail me. The class is a math 146 college class. I need urgent help please my sister passed away any I can get to my homework right now so I am running out of choices Thankyou.
-
“Exploring the Implications of Chapter 5: Recommendations for Administrators, Educators, Parents, and Future Researchers”
Chapter 5.
5.0 introduction
5.1 Summary
5.2 Summary of findings
5.3 Conclusion
5.4 Implication
5.5 Recommendation
Recommendations must bee made to administrators, educators, parents and future researchers -
“Optimal Time Allocation Using Excel Solver” Title: Optimal Time Allocation Using Excel Solver
Formulate and solve the optimal time allocation problem given in the instructions using Excel Solver. The
document that has the numbers and equations will be in the files that are attached. -
Final Assessment: Calculations and Formulas for Payroll at Fort Kent Industries “Mastering the Art of Professional Communication in Academic Writing: A Guide to APA Format and Composition”
Final Assessment Outline
Competency Name: Mathematics for Business
Competency Statement: MAT 140 Mathematics for Business will provide a mathematics foundation for business. Topics covered will
include mathematical analysis for economics, accounting, finance and
management.
Final Assessment Title: Final Assessment
Program Learning Outcomes: PLOs Assessed in this course include:
N/A
Competency Learning Outcomes (CLOs)
1) Identify when to use appropriate equations to solve business problems
2) Calculate trade and cash discounts
3) Determine Markups and Markdowns
4) Identify and calculate different payroll elements
5) Calculate payroll, taxes and deductions.
Purpose of the Assessment
The purpose of the final assessment is to evaluate your knowledge in this course, Mathematics for Business. Demonstration of your
knowledge of each of the course learning objectives (CLO’s) must meet a proficient or exemplary level as seen in the course final
assessment rubric.
Submission Artifacts:
The final assessment requires a PowerPoint with voiceover submission (approximately 12 to 15 minutes) answering the final assessment
case study explaining the process taken with supporting calculations when developing
The new launch Development Plan will:
1) Identify when to use appropriate equations to solve business problems
2) Calculate trade and cash discounts
3) Determine Markups and Markdowns
4) Identify and calculate different payroll elements
5) Calculate payroll, taxes and deductions.
Submission:
Consider the following scenario. For a weekly pay period, you know the following information about the payroll at Fort Kent Industries.
Friday is a mandatory holiday.
Chris receives an annual salary of $89,760.00 based on a 36-hour workweek comprised of four, nine-hour days. She has two hours of
overtime at time-and-a-half and did not work the mandatory holiday.
Lawrence is paid $35.50 per hour based on eight-hour days and a 40-hour workweek. All premium wages are paid at regulatory
minimums. From Sunday to Saturday, he worked 8, 0, 8, 8, 8, 3, and 8 hours, respectively. He will not receive another day off in lieu
for the mandatory holiday.
Greg receives a graduated commission of 2.25% on his first $100,000 in sales and 4.15% on anything higher. His sales during one
week were $123,000. Ignore his holiday or mandatory earnings in your calculations.
Gunnar is paid a straight piecework wage of $2.24 per unit produced. He worked a total of 30 hours during the week, producing one
unit every five minutes. Ignore his holiday or mandatory earnings in your calculations.
The Maine state tax rate for all employees in this scenario is 5.8%.
Social Security tax rate is 6.2% for the employee, and 6.2% for the employer.
The Medicare tax rate us 1.45% for the employee, and 1.45% for the employer.
The Federal tax rate for all employees in this scenario is 22%.
PowerPoint with Voiceover Integration
For all employees combined, determine the:
1. Total regular earnings
2. Overtime earnings
3. Holiday earnings,
4. Holiday worked earnings that Fort Kent Industries must report on its weekly company payroll report.
The PowerPoint must follow outline:
1) Introduction (1-2 slides)
a) Define the key features of the problem as defined above.
2) Calculation (4-8 slides)
a) Illustrate the formulas with calculations for each of the 4 employees.
b) Explain the rational for using the calculations described above.
3) Summary & References
a) Summarize the use necessity of payroll exemptions and how important it is to have correct data and calculations.
b) Reference resources using APA format.
Check Before Submission:
Before submitting, double-check, have you have met the criteria noted below. Did you….
Identify correct calculations and formulas for each employee
Make your presentation engaging, informative, and concise
Include the logical illustrations for each employee
Implement course materials and research materials to support your formulas.
Check for accuracy in composition, APA format, and meeting the guidelines as delineated step 2.
Make certain you are well practiced and articulate materials in a professional manner, (limit ums, like’s and other communication
flaws) -
“Lab 5: Data Analysis” Lab 5: Data Analysis
Click the link below for Lab 5, and complete it on a separate sheet of paper. You do not need to copy the questions. The answers will suffice. When you have finished, click the”Submit Assignment” button. You will be given two options for submitting the Lab.
You can submit a photo, such as a cell phone photo, scan or any other type of photo. You can also simply type your responses into the submission box.
The second option will become more difficult as we begin working with charts and graphs, so a photo will be a lot easier.