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

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.

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:

WRITING LAND
High Quality Assignments
Quality Assignments
Top Grade Essay
Custom Coursework Service
Top Academic Tutor
Writer Writer Name Offer Chat
WRITING LAND

ONLINE

WRITING LAND

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

$73 Chat With Writer
High Quality Assignments

ONLINE

High Quality Assignments

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

$126 Chat With Writer
Quality Assignments

ONLINE

Quality Assignments

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

$91 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

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

$23 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$123 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

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

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

Joint office of gas transporters - Johns lyng group hobart - Incandescent light bulb diagram - Macbeth act 1 test answers - Mary meeker 2019 internet trends report pdf - Divinity original sin 2 obsidian lancet - Belkasoft acquisition tool download - Quantitative Research - Tjx data breach case study - Week 10 - An organism with iscap+p+o+z+y+a+/f’i+ will have a normal functioning lac operon. - Amway the cult of free enterprise pdf - Here is a work breakdown structure for a wedding - Army crew team case study text - Public administration 7 - We didn't start the fire timeline - Half wave rectifier experiment on breadboard - Research Paper - Brandon brown versus yucatan chapter 3 - Charles buck thurman today - Using Narration, Dialogue, and Allusion - Momentum and impulse worksheet - Which of the following should we do first in our analysis of the ‘validity’ of an argument? - Whittlesey dog training club - Social Work - Paladin boot disk - Advantages of hvac transmission system - Systematic layout planning example - Citizens advice bureau blaby - Casimir pulaski day banjo tab - Business growth overview dataset - Importance of knowledge in islam - History Essay - Leccion 8 en el restaurante - How avoid losing money on investments informative speech - Typing work - General aviation - Common access resources examples - Esol entry 2 reading past papers - Center of mass of a semicircular ring - Need 3 Customer journey map - Chemical compound of cement - V character analysis v for vendetta - Don t blame the eater essay - Chapter 4 Interpretations and Results - Research - St george's student union - Current conductor 9 letters - Eec iv stand alone - Hr roles mind map hrm 300 - Dulwich college singapore fees - R Milestone 2 - Arden company reported the following costs and expenses - WRITE TOPIC - Format the text box by applying the subtle effect - Rodney stark sociology 10th edition ebook - 1984 part 2 study guide - The electrical force between charges depends only on the charges - Quality and safety in nursing wgu - Illinois agility test norms - The dreamer of oz - Assignment - Inside dyson a distinctive company case study answers - Punchline algebra book b 14.18 answers - Role of Special Interest Groups Paper - Discussions Respose - Types of Data Discussion - Poems from different cultures - Cortex m4 generic user guide - Types of pld programmable logic devices - Myitlab access chapter 6 grader project - Unity gain bandwidth of 741 op amp - Bid response proposal - Assigment 1 - DQ: The Socrates and the Quest of the moral Truth - Abby ham husband robert lambert - Unit V Annotated Bibliography - Power bank portable charger target - MOS 5101 Case Study Due today by 1000pm CST plagiarism free - Mcquaig word survey login - Global issues - National communication association credo for ethical communication - 0737179697 MAMA SHANANI ABORTION CLINIC IN ELIM - Grind teeth crossword clue - Feynman problem solving algorithm - INFANCY - Restorative Justice - Wgp chemical company case study - Developing ideas penn foster exam - Free osha 300 log excel - Developing Strategic Goals - Artificial neural network ppt - How do i make a brochure in word - Copper nitrate and sodium hydroxide equation - Health - The tools of fiscal policy answers - 02.05 the bill of rights assessment - Growth retrenchment and stability are examples of - Acknowledgement of country wurundjeri example - Systematic and Unsystematic Risk