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

C++ dictionary

26/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:

Math Specialist
A Grade Exams
University Coursework Help
Financial Solutions Provider
Quality Assignments
Chartered Accountant
Writer Writer Name Offer Chat
Math Specialist

ONLINE

Math Specialist

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

$52 Chat With Writer
A Grade Exams

ONLINE

A Grade Exams

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

$56 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

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

$28 Chat With Writer
Financial Solutions Provider

ONLINE

Financial Solutions Provider

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

$63 Chat With Writer
Quality Assignments

ONLINE

Quality Assignments

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

$51 Chat With Writer
Chartered Accountant

ONLINE

Chartered Accountant

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

$65 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

Constructing a phylogenetic tree worksheet answer key - Nigel's service centre geraldton - Mkt 571 client pitch presentation - 14 how do jennifer's educator expenses affect her tax return - Give me liberty 6th edition volume 2 pdf - How are photosynthesis and cellular respiration alike - Questions - Ndss registration form pdf - Twenty four hundred hours - Textual analysis essay outline - Analysis of poem mushrooms by sylvia plath - Big bertha stories by bobbie ann mason - Csi web adventures rookie training - How to make a mummy national geographic - The following information has been obtained for the gocker corporation - Cash payments journal to general ledger - Ethical issues with legalizing weed - Operational acceptance testing explain with example - Wall street journal ipad app problems - Case Study - Spray painting with toothbrush - Hey buddy can you spare a dime worksheet answers - Leo tolstoy what is art summary - Http www comcare gov au careers - 8 necessary life functions - Assignment - Overhead catenary system design - Dave andrews radio leicester - Reflect on and describe a series of incidents, events or a day in their professional life. - V2500 engine training manual - Mrs birling essay plan - Forensic Accounting - Discussion Post - Hand of benediction vs ulnar claw - Shoreline stadium case answers - The other wes moore short summary - Bexhill rail action group - 50-75 Word Discussion reply - Ecce romani 1 exercise 5c answers - Workshop supervisor duties and responsibilities - Lif5800rl p smoke alarm manual - Vita link and learn - Emerson hydrostatic level transmitter - The five i's of microbiology - Vocabulary - Miniver cheevy questions answer key - IP wk15 - Legal ethical and professional issues in information security book - Firm risk scorecard risk classification system - Tamil oral test topics - Compsis at a crossroads case study - The eeg indicates what about lenny - Trill sammy netflix and chill lyrics - KenoshaW - Additional funds needed problems and solutions - Dr ronan murray perth - Health assessment of a school aged child - Mass percent of acetic acid in vinegar - Khan academy rational and irrational numbers - Similarities between virtue theory utilitarianism and deontological ethics - Give me liberty an american history 6th edition pdf - Discussion questions for everyday use by alice walker - Is yeast an r selected or k selected species - Endangered species brochure template - Mintzberg organisational structure theory - Health science technology lesson plans - Anne boykin and savina schoenhofer biography - ANNOTATED POWERPOINT PRESENTATION ON THE IMPORTANCE OF EMPLOYEE MANAGEMENT IN THE HUMAN RESSOURCES DEPARTMENT - Character analysis essay outline - MGT 370-week 1 Discussion - Exercise 1 data interpretation - Joseph william wood the path hulu - Jasper jones jeffrey lu cricket - Cmgt 5 - Health Organization Evaluation - Oracle smart view download for windows 10 - MGMT315 Week 4 Assignment - Hw 5 pt1 - Assignment 1: Combating Juvenile Delinquency - What is the gibbs reflective model - Maxim healthcare novice nurse program - BUS 300 - In a 3-5 page (750-1250 words) essay, answer the following question: - Mental stigma - What is the function of the exercise evaluation guide eeg - Late nite labs ph indicator answers - Market segmentation of coca cola pdf - No warmth could warm nor weather chill him - L oreal color riche shine insensation - Demographic segmentation variables for two wheeler industry - ASSIGNMENTWK50924 - Northumbria university semester dates - Declare a 8x8 two-dimensional array of strings named chessboard. - Diles a los voluntarios que vengan también - Budget - Information Technology Importance in Strategic Planning - Tucker the man and his dream worksheet answers - Online job portal project documentation in php pdf - 5-2 - Chemistry matter and its changes 5th edition pdf - 500 words