Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Data analysis plus excel 2019

27/03/2021 Client: saad24vbs Deadline: 2 Day

LAB SESSION 3

ANALYZING MEAN

INTRODUCTION: Two indispensable statistical decision-making tools for a single

parameter are

(i) Confidence intervals

(ii) Hypothesis tests to investigate theories about parameters.

KNOWN SIGMA

CONFIDENCE INTERVALS

As an introduction, let’s follow Example 8.4 in your text.

image1.png image2.png

Begin a new worksheet and generate 40 random integers the range 0 to 9 in column A. Use the Random Number Generation tool of Excel and then use the INT (integer) function to transform to integers in the range 0 to 9:

Choose: Data > Data Analysis > Random Number Generation > OK

Enter: Number of Variables: 1

Number of Random Numbers: 40

Select: Distribution: Uniform

Enter: Parameters, Between 0 and 10

Output Range: B1 > OK

Enter: in cell A1: =INT(B1)

Click and drag: lower right corner to cell A40

To see the mean, standard deviation and maximum and minimum values for the data set use: Select: Data > Data Analysis > Descriptive Statistics > OK

Enter input and output range as appropriate, and select Summary Statistics

Find the 90% confidence interval for the mean of these values we generate in column A: Choose: Data > Data Analysis Plus** > Z-Estimate: Mean > OK

Enter: Input Range: A1:A40

Standard Deviation (SIGMA): 2.87 > OK

Alpha: .10 > OK

So the 90% confidence interval for the mean is image3.jpg to image4.jpg . ** If “Data Analysis Plus” does not show on the File menu:

Save and Close your excel file

Open: http://www.kellerstatistics.com/KellerStatistics/DataAnalysisPlus Click on: “Download DAPv9” bottom (Mac or Windows)

Save the file > Extract it > open it > double click on Excel file:“Stats_2007-2013_v9b” > Click on “Enable Macros” > Find “Data Analysis Plus” in “Add-Ins” at the menu toolbar of present Excel file > Reopen your previous excel file by dragging inside of present Excel file.

HYPOTHESIS TESTING

A standard final examination in an elementary statistics course is designed to produce a mean score of 75 and a standard deviation of 12. The hypothesis you will try to verify is: "This particular statistics class is above average." At the .05 level of significance, test the claim that the following sample scores reflect an above-average class (assuming sigma = 12):

79 79 78 74 82 89 74 75 78 73 74 84 82 66 84 82 82 71 72 83

Test the hypothesis, "The mean test grade for this class is greater than 75." Choose: Add-Ins > Data Analysis Plus > Z-Test: Mean > OK

Enter: Input Range: A1:A20 or select cells > OK

Hypothesized mean: 75

Standard Deviation (SIGMA): 12 > OK

Alpha: .05 > OK

Questions:

1. What are the formal null and alternative hypotheses?

2. What is the value of the test statistic, and what is your decision? Is the mean of this class above “average”?

UNKNOWN SIGMA

THE CONFIDENCE INTERVAL

To generate a confidence interval using the t-statistic we use Inference about a Mean command, specifying the level of confidence and the column of data for which the estimation is being made.

image5.png

Consider the data presented in exercise 9.31[EX09-031] of your text. Open the data file. Before we complete a 95% confidence interval estimate for the mean length of lunch breaks

at Giant Mart, we check the normal probability plot and boxplot to verify the normality assumption.

Excel uses a test for normality (Chi-Squared Test of Normality), not the probability plot. Choose: Add-Ins > Data Analysis Plus > Chi-Squared Test of Normality > OK

Enter: Input Range: select cells

Select: Labels (if column heading was used) > OK

** IF P-value greater the .05, given distribution is approximately normal.

To complete a 95% confidence interval estimate for the mean length of lunch breaks at Giant Mart complete the following steps:

Choose: Add-Ins > Data Analysis Plus > t-Estimate: Mean > OK

Enter: Input Range: A1:A22

Enter: Alpha: .05 > OK

With 95% confidence we estimate the mean length of lunch breaks at Giant Mart to be between image6.jpg and image7.jpg minutes.

THE T TEST

image8.png

Using text exercise 9.29 [EX02-177] as the basis of our discussion, open the data file. Suppose we have been asked to determine whether this accelerator has decreased the drying time by significantly more than 4% at the 0.01 level.

To perform the test, use the following commands:

Choose: Add-Ins > Data Analysis Plus > t-Test Mean > OK

Enter: Input Range: A2:A9 > OK

Hypothesized mean: 4 Alpha: 0.01 > OK

Question:

3. What are the formal null and alternative hypotheses?

4. Is there sufficient evidence to show that this accelerator has decreased the drying time significantly more than 4% at the .01 level?

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Quality Homework Helper
Academic Master
Essay Writing Help
Engineering Solutions
Maths Master
Engineering Exam Guru
Writer Writer Name Offer Chat
Quality Homework Helper

ONLINE

Quality Homework Helper

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$75 Chat With Writer
Academic Master

ONLINE

Academic Master

I have read your project details. I can do this within your deadline.

$33 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I will cover all the points which you have mentioned in your project details.

$95 Chat With Writer
Engineering Solutions

ONLINE

Engineering Solutions

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$47 Chat With Writer
Maths Master

ONLINE

Maths Master

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$24 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

I have read and understood all your initial requirements, and I am very professional in this task.

$76 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Roots of polynomials exam questions - Bateman and snell management - Newton's laws of motion vocabulary beverly hernandez answer key - 8 steps decision making process example management - Financial and managerial accounting john wild - Ashbourne house bed & breakfast sheringham nr26 8bt - Fronius inverter change wifi password - General survey nursing assessment - R12000 in dollars - Graded assignment-1 - Glos royal hospital map - Virgin atlantic organisational chart - 297-299 monaco street broadbeach waters - Corporate governance failure at satyam pdf - Palisade creek co comprehensive problem 2 - Health and wellbeing responsibility of all poster - Jhs sweet tea v2 manual - It's like pulling teeth a case study in - Big Sell - Sierra company manufactures woven blankets and accounts for product - Commbiz user identification form - Glossary of mining terms - A ___________ gantt chart is a simple and effective way to depict progress on a project. - Navigating Change Through Formal Structures and Systems Discussion - Returned Foreign Terrorist Fighters - Shib live price chart - Role of nurse informaticist in system development life cycle - QUALITATIVE And QUANTITATIVE Journal Article (1 Paper Each) - Assignment, use 2 sources other than the video - Depression is a disease of civilization stephen ilardi at tedxemory - Nelson university of northampton - Ivalongbeach illuminate - Managerial economics and organizational architecture 4th edition pdf - C++ program to convert decimal to binary using functions - Physical landscape of india - W9 law - 100 points of identification nsw - Fusion 360 warning lifting feed plane to topmost ramp - How are microorganisms destroyed by moist heat by dry heat - Fiscal planning in nursing management and leadership - Dr and mrs vandertramp - Introduction TO CRIMINAL JUSTICE - Courage in shawshank redemption - 8-2 Project 3: Multimedia Presentation Submission - International business case study with solution - Https youtu be lp eo5i60ka - Mass effect citadel missions - Outbreak at watersedge answers - Discussion post - Global technology - Maladaptive responses to immune disorders - Basic laboratory techniques experiment 1 report sheet - Wit Movie - Week 3 discussion - Greenhouse effect worksheet answers - Mha/ 516 4 - 11 cadorna street mowbray - Word list for grade 1 - Tipping point leadership ppt - Healthcare Managaement paper - Age structure diagram worksheet - Patricia benner domains of nursing practice - Virginia henderson definition of nursing - Antes yo no (conocer) a ninguno de mis vecinos (neighbors). - Racial Diversity in the Classroom - Purchased equipment on account journal entry - Similarities between perfect competition and monopolistic competition - Energy efficiency calculations worksheet - Double rocker mechanism application - Turn Every Dollar Into Opportunity with a Smart Investment Book - William harvey hospital postcode - Who was john winthrop speaking to in this sermon - Pope watering timer instructions - In one reaction mole of sicl - The first step in the strategic brand management process is ________. - Use the web or other resources to research at least two criminal or civil cases in which recovered files played a significant role in how the case was resolved. - Biology 11.5 speciation through isolation study guide answers - Australia singles top 50 - Virtualization - Examples of 5 levels of leadership - Handy andy inc case study - Bsg game final report - Middlesex county joint health insurance fund - Acme fireworks - Juror 11 12 angry men - Discussion - General mills mission statement - Homework 1 - Can i compare thee to a summer's day - Week 8 discussion tests and measurments - 6 pp slides. rehab programs ( template attached) - How might data analytics hurt policing - Problem - Solution Essay - What is the usual period for cosecant - Managerial Accounting - Company Budgeting - Post war voices emerge 1950s 1960s compare and contrast essay - Stand by me chords - The rising of the moon - Journal entry 15 on course - Nim game smart computer java - Highfield awarding body for compliance habc