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

Keller statistics keller statistics data analysis plus

23/10/2021 Client: muhammad11 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:

Quick N Quality
George M.
Professional Accountant
Professor Smith
Engineering Exam Guru
ECFX Market
Writer Writer Name Offer Chat
Quick N Quality

ONLINE

Quick N Quality

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$34 Chat With Writer
George M.

ONLINE

George M.

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$50 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$39 Chat With Writer
Professor Smith

ONLINE

Professor Smith

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$36 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$17 Chat With Writer
ECFX Market

ONLINE

ECFX Market

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

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

The patriot reverend oliver - Shear force in a beam experiment - Bsbcmm401a make a presentation assessment answers - DIT600 Discussion - English - Test case design techniques guru99 - Form 8888 allocation of refund - Week -1 discussion info governance - Quadratic equation in java source code - Uniform gradient present worth excel - Manipulating NumPy Arrays - HR: Post and responses - Input and output devices notes - Lohmeyer corporation reports - Public mobile to koodo migration offer - Rlc low pass filter transfer function - Www kidsastronomy com solar system htm - Ethical Relativitism - BPSC 021 - Fall 2020 - APA assignment - Budget - Recommendation for ford motor company - MOKUL - Bolon tzacab mayan god - A green pigment that traps energy from sunlight is - Potassium bag it all upright - Bilingual education - Research methods in the social sciences frankfort nachmias pdf - Extrapyramidal side effects medication - You hear: pido bistec con papas fritas. - OPERATIONAL PLANNING - FOLLOW ALL THE BELOW POINTS AND NEED ANSWERS FOR ALL THE POINTS BELOW IN APA FORMAT WITH AT LEAST 250 WORDS - Pachuco cross 4 lines meaning - How to calculate case mix index for hospitals - Reflection paper on organizational behavior - Maximum megahertz project action plan - Spartan cheese stealing ritual - 50 ml graduated cylinder sig figs - Sequence of hunger games - Mad catz ctrlr windows 10 - Business policy case study - Beware do not read this poem meaning - Are dimples a dominant trait - Psy 340 week 1 quiz - Motel 6 - Forces on submerged surfaces - Diles a los voluntarios que vengan también - Mobil oil australia v wellcome international - Brand value chain model example - Bega valley private hospital - Is gatorade or powerade better - Normal consistency of ordinary portland cement - END SEMESTER - American art before and after world war ii presentation - Coca cola product portfolio analysis - Pest control courses melbourne - Dallas world aquarium internship - Clinical Field Experience B: Phonics and Word Recognition: I Do, We Do, You Do - Potassium hydrogen phthalate reaction with sodium hydroxide - Route 121 bus schedule - Ealing advice service lido centre - 3 - los colores fill in the blanks with words for colors based on the cues. - Introducing buddhism prebish 2nd edition pdf - Why were athletes originally given olive wreaths as a reward - Plate tectonics vocabulary answer key - Lady macbeth sleepwalking scene video - The adventure of the speckled band conflict - Ecosystemic crisis intervention - Cold lay tarmac jewsons - Birkenhead medical centre appointments - Tcj push pull calculator - Bibliografia anotada estilo apa - Security Administrator - National american university class action lawsuit - Southwest airlines case study stanford graduate school business - I need this assignment done as followed as in the content APA style no plagisirism please make sure that everything is in details. - Baker c 2011 foundations of bilingual education and bilingualism - Speech outline template for kids - Heresy and Orthodox Belief - Imperial college london blackboard - Textual analysis essay outline - Essential skills training & recruitment - 72 as a product of primes - Decision making grid economics - A literary review worksheet answers - Describe how outsourcing can be used for risk transference - Dividends declared debit or credit - Why do oligopolies exist - Chemistry lab report rubric - Zhuangzi the essential writings sparknotes - Managing GCU Experience - Research Paper - Cross Cultural Management (2500 WORDS) - Management assignment - Assassin's creed odyssey can you save phila - Ethical lapse definition - Case study - What are the problems with a plural executive - Rmit international application form - Human needs theory in nursing - Simnet instant help