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

18/11/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:

Essay & Assignment Help
Quick Mentor
Assignment Hub
Write My Coursework
Smart Tutor
Professional Accountant
Writer Writer Name Offer Chat
Essay & Assignment Help

ONLINE

Essay & Assignment Help

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$17 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$19 Chat With Writer
Assignment Hub

ONLINE

Assignment Hub

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$50 Chat With Writer
Write My Coursework

ONLINE

Write My Coursework

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$16 Chat With Writer
Smart Tutor

ONLINE

Smart Tutor

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

$42 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

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

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

Macquarie infrastructure and real assets mira - Moral doctrines and moral theories - Mohs hardness scale worksheet - Extract from the boy in the striped pyjamas - 8.04 leisure writing assignment answers - BI Week 14 Assignment - Marketing Strategies New England College - PAPER - How to make a tree diagram in word - Nursing Research Methods #5 - Sociology of Everyday Life - Time sert tap size - Need a use case diagram - Qualitative analysis flow chart cations - 13 ebro way willetton - Coca cola company mission and vision statement - First octa core phone - Queensland building and construction commission act - Ffff yyyy zzzz - Ikkyu crow with no mouth pdf - 3 theories of term structure of interest rates - Lausanne conference on world evangelism - Barbarossa spiced rum nutritional information - What happens if you fail a subject at uts - Who are the stakeholders in nursing education curriculum development - Nutanix xtreme computing platform - How to breed a wisp - Tectonics and continental drift lab answers - Managerial Accounting_Problem3 - Bbc bitesize gcse waves - Must Be completed TODAY by 9pmEST!!!!!!! - Which of the following is a disadvantage of alternative mobility paths? - Chcage005 - Suppose the dollar interest rate and the pound sterling - Ted lavender in the things they carried - Evans technology has the following capital structure - Sole trader contractor agreement - Four p's of marketing - How to find z score on statcrunch - Calculating work and power by climbing stairs - Preparation of p bromoacetanilide from acetanilide mechanism - House of quality example for food - Discussion Board - Dominant impression in descriptive writing - Discuss your understanding of the concepts of cultural politics, cultural domination, accommodation and resistance as relates to syncretism and the emergence of the culture of the enslaved (the precursor to African American culture) in the US. - How accurate is bones - Where can i sell my dental instruments - Detecting Plagiarism - Computer work - Country manager simulation quiz answers - Mk k545whi data socket module rj45 - Capacitance of 3 phase transmission line - PLC5 Power Supply - Clarissa and richard dalloway relationship - Problem Set 2 - Roma mitchell secondary college toni carellas - Just dew it corporation reports the following balance sheet information for 2011 and 2012. - Alpha chiang elements of dynamic optimization - Module 03 Written Assignment - The Case Manager - Network diagram with ip addresses - Short essays - Crypto currencies, Blockchain and security - Benefits of empowering staff - Http billofrightsinstitute org educate educator resources landmark cases - Mistakes were made but not by me pdf - What is the smallest three digit number - Leddy and pepper's professional nursing pdf - Cultural Diversity - Wet stacking diesel truck - Northwestern human services pa - Two snowcats in antarctica are towing a housing - Self reflection strengths and weaknesses essay - Lab homework - Physician assisted suicide research paper outline - Thank you letter to teacher - APPLICATION OF HEALTH CARE INFORMATION SYSTEMS - Jodee rich net worth - Hudl camera not working - Prom king and queen nomination forms - Iinet net au voipsetup - Access 2016 module 1 sam project 1a - Experiment 14 identification of selected anions answers - Measuring Progress and Requirements - Films on demand database ashford - Canmark research center airport survey - Aglc 4 quick guide - Multicultural centre for women's health - Annotated Bibligraphy - Marketing plan for solar energy company - 8 32 hole diameter - Discussion week 10 - IT Information Dashboards Essay - 3 Pages - Due 3rd Oct - Www newadvent org rosary - Secret world legends the meowling - 325 words - Suppose stark ltd just issued a dividend of - The mr mc rule applies only to pure competition - Writing Prompt Five - Alice walker everyday use discussion questions answers - Question 2 - Access module 3 sam project 1