Scribd Logo
Upload

Welcome to Scribd!

  • 33 views

    BUSI 650 Assignment 1

    Uploaded by

    zikokhan
    This document appears to be an assignment submission from a student named Junayed Ibne Ahsan for a business analytics course. The assignment contains [2] questions regarding hypothesis testing of average lifespans of lightbulbs and average heights of Canadians. For each question, the student provides the requested calculations and interpretations at a 5% significance level to test the given hypotheses. The assignment also includes [2] questions testing SQL joins, for which the student provides the correct queries to produce the requested output tables.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    BUSI 650 Assignment 1

    Uploaded by

    zikokhan
    33 views4 pages
    This document appears to be an assignment submission from a student named Junayed Ibne Ahsan for a business analytics course. The assignment contains [2] questions regarding hypothesis testing of average lifespans of lightbulbs and average heights of Canadians. For each question, the student provides the requested calculations and interpretations at a 5% significance level to test the given hypotheses. The assignment also includes [2] questions testing SQL joins, for which the student provides the correct queries to produce the requested output tables.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document appears to be an assignment submission from a student named Junayed Ibne Ahsan for a business analytics course. The assignment contains [2] questions regarding hypothesis testing of average lifespans of lightbulbs and average heights of Canadians. For each question, the student provides the requested calculations and interpretations at a 5% significance level to test the given hypotheses. The assignment also includes [2] questions testing SQL joins, for which the student provides the correct queries to produce the requested output tables.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    33 views4 pages

    BUSI 650 Assignment 1

    Uploaded by

    zikokhan
    This document appears to be an assignment submission from a student named Junayed Ibne Ahsan for a business analytics course. The assignment contains [2] questions regarding hypothesis testing of average lifespans of lightbulbs and average heights of Canadians. For each question, the student provides the requested calculations and interpretations at a 5% significance level to test the given hypotheses. The assignment also includes [2] questions testing SQL joins, for which the student provides the correct queries to produce the requested output tables.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 4

    Assignment 1

    JUNAYED IBNE AHSAN

    Student ID: 2208504

    University Canada West

    BUSI 650: BUSINESS ANALYTICS

    Karim Souidi

    October 28, 2022


    Q1: A company states that their lightbulb lasts 20. 103 hours on average. A customer

    association would like to test this hypothesis at the 5% level.

    a) What is the parameter that the association wants to test?

    b) Note that μ0 =20.103 ; what’s the hypothesis that the association is looking to test?

    c) What does the type I error mean in this example?

    d) What does the type II error mean in this example?

    e) How do you interpret the significance level: 5%?

    Answer 1

    a) Average life of the population of light bulb

    b) Association wants to test, µ≠20.103.

    c) Type 1 error: Though the mean lifetime of a population of all the bulbs is actually

    20.10³ hours, we reject it

    d) Type two error: Accepting that the mean lifetime of a population of all the bulbs is

    20.10³ hours though it is false.

    e) Interpretation of 5% significance level: This is the 5% probability that the null

    hypothesis. The mean lifetime of the population of all bulbs is 20.10³ hours is maybe

    happened by chance.

    Q2: The average height of a sample of 10 Canadians is 176 cm, and the variance of

    population height is 100 cm 2

    a) Should you reject the fact that the average height of Canadians is 170 cm, at the 5%

    significance level?

    b) Should you reject the fact the that the average height of Canadians is less than 170

    cm, at the 5% significance level?

    c) Calculate and interpret the p-value.

    1
    Answer 2

    a) We should not reject the fact that the average height of a Canadian is 170 cm at a 5%

    level of significance.

    b) We should not reject the fact that the average height of a Canadian is 170 cm at a 5%

    level of significance.

    c) The p-value of the test is 0.97128 , which is high enough to not reject H0

    a) Write the SQL query that produces the table below

    2
    Answer a)

    SELECT

    d.DeptName,

    d.DeptNo,

    e.LastName

    FROM departments d

    LEFT JOIN employee e

    ON d.DeptNo = e.DeptNo;

    b) Write the SQL query that produces the table below

    Answer b)

    SELECT

    d.DeptName,

    e.DeptNo,

    e.LastName

    FROM departments d

    RIGHT JOIN employees e

    ON e.DeptNo = d.DeptNo;

    You might also like