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 for mac

15/10/2021 Client: muhammad11 Deadline: 2 Day

Statistics

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.

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 to .

** 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.

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 and minutes.

THE T TEST

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?

Assignment

• Answer the 3 questions inside the workshop plus:

• EXERCISE 8.41

• EXERCISE 8.125

• EXERCISE 9.60

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
Helping Hand
Calculation Guru
Coursework Helper
Top Class Engineers
Smart Tutor
Writer Writer Name Offer Chat
Math Specialist

ONLINE

Math Specialist

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$49 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$48 Chat With Writer
Calculation Guru

ONLINE

Calculation Guru

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
Coursework Helper

ONLINE

Coursework Helper

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

$35 Chat With Writer
Top Class Engineers

ONLINE

Top Class Engineers

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

$27 Chat With Writer
Smart Tutor

ONLINE

Smart Tutor

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

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

Cqc notifications pressure sores - Human Resources Management - Enable data integrity access lookup wizard - What functional groups are present in the following compound - Essay - Visio 2016 entity relationship diagram - The classical approaches as a whole were criticized because - What is the conjugate acid of hco3 - Bayer urine test strips color chart - International Considerations Scenario - The outsiders multiple choice questions - Describe the eight steps in the decision making process - Power triangle of ac circuit - Literary Theory Fairy Tale Assignment - 200 words - Joint application development example - Probability distribution ppt presentation - Great homer street market - Dhl express annual report 2019 - Researchers endeavoring to conduct an online study - Complete decongestive therapy course - Connect Math- 33 math questions - Essay questions - Saints row 2 female formulas - For psychological egoism to be valid we must show people - Speech after being convicted of voting - Indian plumbing skills council - Haydn nelson mass imslp - What is the greatest threat to biodiversity - Aiphone ac-10s master code reset - Capital structure calculation questions and answers - Lorelei poem analysis - A changing world thesis and outline - How Essay Writing Service Reviews Can Help You Choose the Best Option - Cipd developing professional practice assignment examples - Clinical significance vs statistical significance in nursing research - How to write arabic numbers 1 20 - How would you describe animal like protists - Auditing it infrastructures for compliance - Dave carroll united breaks guitars song 2 - Asc 350 40 pwc - Separating sand and salt - US Census Homeownership Rate - Barriers to effective communication in management - Coca cola inputs transformation process and outputs - According to psychoanalytic therapy human beings are - Hemophilia pedigree chart royal family - Generic conventions of horror - Rummler brache swim lane diagram - Engr 436 - 1/20 as a percentage - Www det wa edu au aboriginal education - Richard zachariah sarah hyde - English Comp 2 week 9 - Transaction processing system example companies - Who warned, “advertisements contain the only truth to be relied on in a newspaper?” - Multi channeled nonverbal communication definition - Thinking critically about ethical issues ruggiero pdf - Analyzing your hr landscape - WK 1, HCS 457: DR 1 - Homework - List of paramagnetic materials - Criminal Justice: Suicide - Example of a character sketch bible study - Cross site request forgery - Homework 4 2 mystatlab module four problem set - Marilyn frye birdcage metaphor - Leslie sansone older adults walk and firm 1998 - Ust ct scan price - Westmont college employment - Why mse is important - El police rd to melba tunnel - Image and preimage of a function - Refer to the circuit shown in fig 8.64 calculate - Final research paper - Glasgow angling centre catalogue - Cell organelles worksheet page 3 - As nzs 2161 occupational protective gloves - Semhs school loop - Applying ethics a text with readings 11th edition pdf - Converting between kp and kc - Business FP3022 - Assessment 1 - What is killerpapers? - Competitive profile matrix of hershey company - Discussion - Human resource management data flow diagram - Who's picking up the puffed rice? - Holding everything else constant if the required reserve ratio falls - Friday night lights football quotes - What sound does ë make in english - In binary multiplication 1 1 - Can terrorism be morally justified - Rituals Assignment - What does the net change in the potato sample indicate - 23 dbm to mw - 104 taos ct dauphin island al 36528 - Roberto a help desk technician receives a call from sally - Communication - Security Architecture - Discussion - As3000 wiring rules pdf free