My Blog

Tag: Statistics

  • [Solved] Rejecting and Failing to Reject the Null Hypothesis

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering Rejecting and Failing to Reject the Null Hypothesis.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] Milestone 2

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    Help understand statistic milestones – ## MilestoneTwoGuidelinesandRubric-IHP-340-19721-M01Stats-HealthcareProfessionals2025C-3May-Jun.pdf **## MilestoneTwoGuidelinesandRubric-IHP-340-19721-M01Stats-HealthcareProfessionals2025C-3May-Jun.pdf** IHP 340 Milestone Two Guidelines and Rubric Overview In M…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Help understand statistic milestones

    – ## MilestoneTwoGuidelinesandRubric-IHP-340-19721-M01Stats-HealthcareProfessionals2025C-3May-Jun.pdf

    **## MilestoneTwoGuidelinesandRubric-IHP-340-19721-M01Stats-HealthcareProfessionals2025C-3May-Jun.pdf**

    IHP 340 Milestone Two Guidelines and Rubric

    Overview

    In Milestone Two, you will continue composing your final project by adding additional information on research methods and key findings.

    Prompt

    For this milestone assignment, address the following in the article you have selected for the final project:

    Additional Research Methods

    Identify the data analysis methods used and explain why the methods are appropriate based on the research question.

    Discuss the potential weaknesses of the data analysis methods used. Support your discussion with examples from the study.

    Describe the key demographics of the population sampled and identify the inclusion and exclusion criteria for participants.

    Key Findings:

    State the results of the research, describing how the researchers determined whether the results are statistically significant.

    Describe the differences in the results between the groups in the study and support your description with examples from the study.

    What to Submit

    This milestone assignment should be submitted as a 1-page paper with 12-point Times New Roman font, double spacing, and one-inch margins, using APA formatting and citation style

    guidelines.

    Milestone Two Rubric

    Criteria Exemplary (100%) Proficient (85%) Needs Improvement (55%) Not Evident (0%) Value

    Research Methods: Data

    Analysis Methods

    Identifies the data analysis

    methods used and explains

    why the methods are

    appropriate based on the

    research question

    Identifies the data analysis

    methods used and explains

    why the methods are

    appropriate based on the

    research question but

    explanation is lacking

    Identifies the data analysis

    methods used but does not

    explain why the methods are

    appropriate based on the

    research question

    Does not identify the data

    analysis methods used or

    explain why the methods are

    appropriate based on the

    research question

    18

    

    [https://app.readspeaker.com/cgi-bin/rsent?customerid=9568&url=https%3A%2F%2Flearn.snhu.edu%2Fcontent%2Fenforced%2F1922599-IHP-340-19721.202551-1%2FMilestone%2520Two%2520Guidelines%2520and%2520Rubric.html&lang=en_us&readid=d2l_read_element_1](https://app.readspeaker.com/cgi-bin/rsent?customerid=9568&url=https%3A%2F%2Flearn.snhu.edu%2Fcontent%2Fenforced%2F1922599-IHP-340-19721.202551-1%2FMilestone%2520Two%2520Guidelines%2520and%2520Rubric.html&lang=en_us&readid=d2l_read_element_1)

    Criteria Exemplary (100%) Proficient (85%) Needs Improvement (55%) Not Evident (0%) Value

    Research Methods:

    Weakness of the Data

    Analysis Methods

    Discusses the potential

    weaknesses of the data

    analysis methods used and

    supports discussion with

    exemplary examples

    Discusses the potential

    weaknesses of the data

    analysis methods used and

    supports discussion with

    proficient examples

    Discusses the potential

    weaknesses of the data

    analysis methods used but

    does not support discussion

    with examples

    Does not discuss the potential

    weaknesses of the data

    analysis methods used

    18

    Research Methods: Key

    Demographics

    Describes the key

    demographics of the

    population sampled and

    identify the inclusion and

    exclusion criteria for

    participants

    Describes the key

    demographics of the

    population sampled but does

    not identify either the inclusion

    or exclusion criteria for

    participants

    Describes the key

    demographics of the

    population sampled but does

    not identify the inclusion and

    exclusion criteria for

    participants

    Does not describe the key

    demographics of the

    population sampled or identify

    the inclusion and exclusion

    criteria for participants

    18

    Key Findings: Results of the

    Research

    States the results of the

    research and determines the

    statistical significance

    States the results of the

    research and determines the

    statistical significance but

    response is lacking

    States the results of the

    research but does not

    determine the statistical

    significance

    Does not state the results of

    the research or determine the

    statistical significance

    18

    Key Findings: Difference in

    the Results

    Describes the differences in

    the results between the groups

    in the study and supports

    description with exemplary

    examples from the study

    Describes the differences in

    the results between the groups

    in the study and supports

    description with examples from

    the study

    Describes the differences in

    the results between the groups

    in the study but does not

    support description with

    exemplary examples from the

    study

    Does not describe the

    differences in the results

    between the groups in the

    study or support description

    with exemplary examples from

    the study

    18

    Articulation of Response Submission is free of errors of

    organization and grammar

    Submission contains errors of

    organization and grammar, but

    errors are limited enough so

    that the assignment can be

    understood

    Submission has major errors

    related to organization and

    grammar that negatively

    impact readability and

    articulation of main ideas

    Submission has critical errors

    related to organization and

    grammar that prevent

    understanding of ideas

    10

    Total: 100%

    **## MilestoneTwoGuidelinesandRubric-IHP-340-19721-M01Stats-HealthcareProfessionals2025C-3May-Jun.pdf**

    IHP 340 Milestone Two Guidelines and Rubric

    Overview

    In Milestone Two, you will continue composing your final project by adding additional information on research methods and key findings.

    Prompt

    For this milestone assignment, address the following in the article you have selected for the final project:

    Additional Research Methods

    Identify the data analysis methods used and explain why the methods are appropriate based on the research question.

    Discuss the potential weaknesses of the data analysis methods used. Support your discussion with examples from the study.

    Describe the key demographics of the population sampled and identify the inclusion and exclusion criteria for participants.

    Key Findings:

    State the results of the research, describing how the researchers determined whether the results are statistically significant.

    Describe the differences in the results between the groups in the study and support your description with examples from the study.

    What to Submit

    This milestone assignment should be submitted as a 1-page paper with 12-point Times New Roman font, double spacing, and one-inch margins, using APA formatting and citation style

    guidelines.

    Milestone Two Rubric

    Criteria Exemplary (100%) Proficient (85%) Needs Improvement (55%) Not Evident (0%) Value

    Research Methods: Data

    Analysis Methods

    Identifies the data analysis

    methods used and explains

    why the methods are

    appropriate based on the

    research question

    Identifies the data analysis

    methods used and explains

    why the methods are

    appropriate based on the

    research question but

    explanation is lacking

    Identifies the data analysis

    methods used but does not

    explain why the methods are

    appropriate based on the

    research question

    Does not identify the data

    analysis methods used or

    explain why the methods are

    appropriate based on the

    research question

    18

    

    [https://app.readspeaker.com/cgi-bin/rsent?customerid=9568&url=https%3A%2F%2Flearn.snhu.edu%2Fcontent%2Fenforced%2F1922599-IHP-340-19721.202551-1%2FMilestone%2520Two%2520Guidelines%2520and%2520Rubric.html&lang=en_us&readid=d2l_read_element_1](https://app.readspeaker.com/cgi-bin/rsent?customerid=9568&url=https%3A%2F%2Flearn.snhu.edu%2Fcontent%2Fenforced%2F1922599-IHP-340-19721.202551-1%2FMilestone%2520Two%2520Guidelines%2520and%2520Rubric.html&lang=en_us&readid=d2l_read_element_1)

    Criteria Exemplary (100%) Proficient (85%) Needs Improvement (55%) Not Evident (0%) Value

    Research Methods:

    Weakness of the Data

    Analysis Methods

    Discusses the potential

    weaknesses of the data

    analysis methods used and

    supports discussion with

    exemplary examples

    Discusses the potential

    weaknesses of the data

    analysis methods used and

    supports discussion with

    proficient examples

    Discusses the potential

    weaknesses of the data

    analysis methods used but

    does not support discussion

    with examples

    Does not discuss the potential

    weaknesses of the data

    analysis methods used

    18

    Research Methods: Key

    Demographics

    Describes the key

    demographics of the

    population sampled and

    identify the inclusion and

    exclusion criteria for

    participants

    Describes the key

    demographics of the

    population sampled but does

    not identify either the inclusion

    or exclusion criteria for

    participants

    Describes the key

    demographics of the

    population sampled but does

    not identify the inclusion and

    exclusion criteria for

    participants

    Does not describe the key

    demographics of the

    population sampled or identify

    the inclusion and exclusion

    criteria for participants

    18

    Key Findings: Results of the

    Research

    States the results of the

    research and determines the

    statistical significance

    States the results of the

    research and determines the

    statistical significance but

    response is lacking

    States the results of the

    research but does not

    determine the statistical

    significance

    Does not state the results of

    the research or determine the

    statistical significance

    18

    Key Findings: Difference in

    the Results

    Describes the differences in

    the results between the groups

    in the study and supports

    description with exemplary

    examples from the study

    Describes the differences in

    the results between the groups

    in the study and supports

    description with examples from

    the study

    Describes the differences in

    the results between the groups

    in the study but does not

    support description with

    exemplary examples from the

    study

    Does not describe the

    differences in the results

    between the groups in the

    study or support description

    with exemplary examples from

    the study

    18

    Articulation of Response Submission is free of errors of

    organization and grammar

    Submission contains errors of

    organization and grammar, but

    errors are limited enough so

    that the assignment can be

    understood

    Submission has major errors

    related to organization and

    grammar that negatively

    impact readability and

    articulation of main ideas

    Submission has critical errors

    related to organization and

    grammar that prevent

    understanding of ideas

    10

    Total: 100%

  • [Solved] Journal post

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    Help organizing my thoughts – ## ModuleFiveShortPaperGuidelinesandRubric-IHP-340-19721-M01Stats-HealthcareProfessionals2025C-3May-Jun.pdf **## ModuleFiveShortPaperGuidelinesandRubric-IHP-340-19721-M01Stats-HealthcareProfessionals2025C-3May-Jun.pdf** IHP 340 Module Five Short Paper Guidelines and Rub…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Help organizing my thoughts

    – ## ModuleFiveShortPaperGuidelinesandRubric-IHP-340-19721-M01Stats-HealthcareProfessionals2025C-3May-Jun.pdf

    **## ModuleFiveShortPaperGuidelinesandRubric-IHP-340-19721-M01Stats-HealthcareProfessionals2025C-3May-Jun.pdf**

    IHP 340 Module Five Short Paper Guidelines and Rubric

    Overview

    This short paper assignment will help you understand hypothesis testing and its relationship to research questions.

    Prompt

    Read the short paper scenario below and answer the questions using the scenario and what you have learned in this course.

    Scenario

    The recommended number of calories for a young, active, female adult to consume in a day is 2,200 calories. Suppose you’re a nutrition consultant for the female sports team at College

    Great. You would like to know whether the average amount of calories consumed per day, on average, for the female, varsity sports players at your college is equal to the recommended

    amount, 2,200 calories.

    1. Describe how you could choose a sample from the population of all female varsity sports players at College Great.

    2. Write out a research question and provide a description of data.

    a. Write out the research question this nutritionist is interested in finding an answer to in your own words.

    b. Describe what data you would collect on this sample to answer the research question. Make sure you collect data on each variable that is part of your research question.

    3. State the null hypothesis, H , and alternative hypothesis, H , that go along with your research question:

    a. In words

    b. Using statistical notation

    4. Provide descriptive statistics and graph suggestions.

    a. What descriptive statistics would you provide that would help you answer this research question?

    b. What graph(s) could you provide that would help you answer this research question?

    Now suppose others at the college get interested in this study, and they want to know if the female varsity sports players consume more calories than female students that do not play

    varsity sports.

    1. Write out this research question in your own words.

    2. Identify the two variables you would need to collect data on from each subject to answer this research question.

    3. Identify each variable as categorical or quantitative (continuous).

    o a

    

    [https://app.readspeaker.com/cgi-bin/rsent?customerid=9568&url=https%3A%2F%2Flearn.snhu.edu%2Fcontent%2Fenforced%2F1922599-IHP-340-19721.202551-1%2FModule%2520Five%2520Short%2520Paper%2520Guidelines%2520and%2520Rubric.html&lang=en_us&readid=d2l_read_element_1](https://app.readspeaker.com/cgi-bin/rsent?customerid=9568&url=https%3A%2F%2Flearn.snhu.edu%2Fcontent%2Fenforced%2F1922599-IHP-340-19721.202551-1%2FModule%2520Five%2520Short%2520Paper%2520Guidelines%2520and%2520Rubric.html&lang=en_us&readid=d2l_read_element_1)

    4. State the null hypothesis, Ho, and alternative hypothesis, Ha, that correspond with your research question:

    a. In words

    b. Using statistical notation

    5. What descriptive statistics would you provide that would help you answer this research question?

    6. What graph(s) could you provide that would help you answer this research question?

    What to Submit

    Submit your paper as a Microsoft Word document that is roughly 2 pages in length, with double spacing, 12-point Times New Roman font, and one-inch margins. References are not

    required. The point of this paper is to show how well you understand hypothesis testing. However, if you do provide information from a published resource, be sure to cite and reference it

    using APA style.

    Module Five Short Paper Rubric

    Criteria Exemplary (100%) Proficient (85%) Needs Improvement (55%) Not Evident (0%) Value

    Research Question and

    Variables

    Research questions and

    variable information provided

    are correct

    Some slight errors in research

    questions or variable

    information, but majority

    correct

    Major error in research

    questions or variable

    information

    Major errors in research

    questions and in variable

    information

    30

    Hypothesis Statements Hypotheses correctly

    expressed in very clear written

    and notation form

    Hypotheses expressed in

    written and notation form with

    minor errors

    Hypotheses expressed in

    written and notation form with

    major errors

    Hypotheses not expressed in

    written and notation form

    30

    Descriptive Statistics and

    Graphs

    Correct descriptive statistics

    and graphs clearly provided

    Descriptive statistics and

    graphs provided with minor

    errors

    Descriptive statistics and

    graphs provided with major

    errors

    Descriptive statistics and

    graphs not provided

    30

    Articulation of Response Submission is free of errors of

    organization and grammar

    Submission contains errors of

    organization and grammar, but

    errors are limited enough so

    that the assignment can be

    understood

    Submission has major errors

    related to organization and

    grammar that negatively

    impact readability and

    articulation of main ideas

    Submission has critical errors

    related to organization and

    grammar that prevent

    understanding of ideas

    10

    Total: 100%

    **## ModuleFiveShortPaperGuidelinesandRubric-IHP-340-19721-M01Stats-HealthcareProfessionals2025C-3May-Jun.pdf**

    IHP 340 Module Five Short Paper Guidelines and Rubric

    Overview

    This short paper assignment will help you understand hypothesis testing and its relationship to research questions.

    Prompt

    Read the short paper scenario below and answer the questions using the scenario and what you have learned in this course.

    Scenario

    The recommended number of calories for a young, active, female adult to consume in a day is 2,200 calories. Suppose you’re a nutrition consultant for the female sports team at College

    Great. You would like to know whether the average amount of calories consumed per day, on average, for the female, varsity sports players at your college is equal to the recommended

    amount, 2,200 calories.

    1. Describe how you could choose a sample from the population of all female varsity sports players at College Great.

    2. Write out a research question and provide a description of data.

    a. Write out the research question this nutritionist is interested in finding an answer to in your own words.

    b. Describe what data you would collect on this sample to answer the research question. Make sure you collect data on each variable that is part of your research question.

    3. State the null hypothesis, H , and alternative hypothesis, H , that go along with your research question:

    a. In words

    b. Using statistical notation

    4. Provide descriptive statistics and graph suggestions.

    a. What descriptive statistics would you provide that would help you answer this research question?

    b. What graph(s) could you provide that would help you answer this research question?

    Now suppose others at the college get interested in this study, and they want to know if the female varsity sports players consume more calories than female students that do not play

    varsity sports.

    1. Write out this research question in your own words.

    2. Identify the two variables you would need to collect data on from each subject to answer this research question.

    3. Identify each variable as categorical or quantitative (continuous).

    o a

    

    [https://app.readspeaker.com/cgi-bin/rsent?customerid=9568&url=https%3A%2F%2Flearn.snhu.edu%2Fcontent%2Fenforced%2F1922599-IHP-340-19721.202551-1%2FModule%2520Five%2520Short%2520Paper%2520Guidelines%2520and%2520Rubric.html&lang=en_us&readid=d2l_read_element_1](https://app.readspeaker.com/cgi-bin/rsent?customerid=9568&url=https%3A%2F%2Flearn.snhu.edu%2Fcontent%2Fenforced%2F1922599-IHP-340-19721.202551-1%2FModule%2520Five%2520Short%2520Paper%2520Guidelines%2520and%2520Rubric.html&lang=en_us&readid=d2l_read_element_1)

    4. State the null hypothesis, Ho, and alternative hypothesis, Ha, that correspond with your research question:

    a. In words

    b. Using statistical notation

    5. What descriptive statistics would you provide that would help you answer this research question?

    6. What graph(s) could you provide that would help you answer this research question?

    What to Submit

    Submit your paper as a Microsoft Word document that is roughly 2 pages in length, with double spacing, 12-point Times New Roman font, and one-inch margins. References are not

    required. The point of this paper is to show how well you understand hypothesis testing. However, if you do provide information from a published resource, be sure to cite and reference it

    using APA style.

    Module Five Short Paper Rubric

    Criteria Exemplary (100%) Proficient (85%) Needs Improvement (55%) Not Evident (0%) Value

    Research Question and

    Variables

    Research questions and

    variable information provided

    are correct

    Some slight errors in research

    questions or variable

    information, but majority

    correct

    Major error in research

    questions or variable

    information

    Major errors in research

    questions and in variable

    information

    30

    Hypothesis Statements Hypotheses correctly

    expressed in very clear written

    and notation form

    Hypotheses expressed in

    written and notation form with

    minor errors

    Hypotheses expressed in

    written and notation form with

    major errors

    Hypotheses not expressed in

    written and notation form

    30

    Descriptive Statistics and

    Graphs

    Correct descriptive statistics

    and graphs clearly provided

    Descriptive statistics and

    graphs provided with minor

    errors

    Descriptive statistics and

    graphs provided with major

    errors

    Descriptive statistics and

    graphs not provided

    30

    Articulation of Response Submission is free of errors of

    organization and grammar

    Submission contains errors of

    organization and grammar, but

    errors are limited enough so

    that the assignment can be

    understood

    Submission has major errors

    related to organization and

    grammar that negatively

    impact readability and

    articulation of main ideas

    Submission has critical errors

    related to organization and

    grammar that prevent

    understanding of ideas

    10

    Total: 100%

  • [Solved] Crituqe

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering Crituqe.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] tax

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering tax.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] Math 1342 excel spresdsheet

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    Can anyone help with excel and statistic? – ## chapter6excelassignment.docx – ## math1342_database3.xlsx **## chapter6excelassignment.docx** 1. Top of Form Again, you will use the student survey from the Excel spreadsheet given at the beginning of the course: [MATH 1342 Database.xlsx](https://cont…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Can anyone help with excel and statistic?

    – ## chapter6excelassignment.docx

    – ## math1342_database3.xlsx

    **## chapter6excelassignment.docx**

    1.

    Top of Form

    Again, you will use the student survey from the Excel spreadsheet given at the beginning of the course:
    [MATH 1342 Database.xlsx](https://content.ctcd.edu/courses/math1342-lec/m23/docs/math1342_database.xlsx)

    Find two free cells in the spreadsheet to enter the appropriate formulas to find the mean and standard deviation of the DRIVE variable by using
    **=AVERAGE(A2:A36)** and =
    **STDEV(A2:A36)**.

    (Round your answers to 5 decimal places)

    Fill in the blank:

    The
    **mean** of the DRIVE variable is
    **Blank 1**.

    The
    **standard deviation** of the DRIVE variable is
    **Blank 2**.

    · Blank 1

    · Blank 2

    Bottom of Form

    2.

    Top of Form

    Question 2

    **Question 2**

    **2 Points**

    Question 2

    Assuming that this variable is normally distributed, what proportion of the data would you predict to be less than 40 minutes? This would be based on the calculated probability.

    To approximate this probability with Excel, find a free cell on the spreadsheet and use the formula
    **=NORM.DIST(40,mean,stdev,TRUE)**. For the "mean" and "stdev" in the formula, you
    _don't_ want to type those words, you want to actually enter the cell numbers in which you just found the average and standard deviation of your DRIVE variable.

    (Keep your answer in decimal form and round your answer to 3 decimal places)

    **Fill in the Blank:** The proportion of values that I expect to be less than 40 minutes is _____________.

    **Blank 1**

    · Blank 1

    Bottom of Form

    3.

    Top of Form

    Question 3

    **Question 3**

    **2 Points**

    Question 3

    Now, determine the
    **_actual_** proportion of data points in the dataset that fall within this range (less than 40 minutes). To find the actual proportion, sort the DRIVE variable, and count how many of the data points are less than 40. Then, divide that number by the total of 35 data points.

    (Keep your answer in decimal form and round your answer to 3 decimal places)

    **Fill in the Blank:** The actual proportion of values less than 40 minutes is ___________.

    **Blank 1**

    · Blank 1

    Bottom of Form

    4.

    Top of Form

    Question 4

    **Question 4**

    **2 Points**

    Question 4

    How does your predicted probability from question 2 compare to the actual probability calculated in question 3? In other words, if these values are different, why do you think they're different, etc?

    Option A

    The probability calculations are different. In part 2, we calculated the probability based on the assumption that the distribution of the "drive" variable is normally distributed. If the distribution is not bell-shaped, then the probability estimation (in part 2) would not be accurate.

    Option B

    The probability calculations are the same.

    Option C

    The probability calculations are different. This must mean that something is wrong with our technology.

    Bottom of Form

    **## math1342_database3.xlsx**

    ## MATH399 Data Sheet

    | | | | | | | | | | | | |
    | — | — | — | — | — | — | — | — | — | — | — | — |
    | Drive (miles) | Birth Year | State | Shoe Size | Height (inches) | Sleep (hours) | Gender | Class Standing | Car Color | TV (hours) | Money (dollars) | Coin |
    | 4 | 1988 | NY | 9 | 69 | 7 | F | Sophomore | blue | 5 | 21.00 | 5 |
    | 6 | 1990 | OR | 13 | 75 | 10 | M | Junior | silver | 6 | 7.00 | 4 |
    | 6 | 1978 | MI | 10 | 66 | 6 | M | Freshman | black | 5 | 34.00 | 3 |
    | 20 | 1977 | IL | 5 | 62 | 7 | F | Junior | black | 3 | 10.00 | 2 |
    | 20 | 1985 | OR | 7 | 65 | 4 | F | Sophomore | green | 1 | 46.00 | 4 |
    | 25 | 1988 | CA | 8 | 69 | 6 | F | Senior | silver | 4 | 30.00 | 4 |
    | 25 | 1995 | GA | 9 | 63 | 7 | M | Junior | silver | 3 | 53.00 | 5 |
    | 28 | 1992 | NY | 7 | 67 | 4 | F | Freshman | black | 1 | 25.00 | 4 |
    | 29 | 1990 | TX | 11 | 70 | 7 | M | Freshman | silver | 2 | 28.00 | 3 |
    | 33 | 1985 | SC | 11 | 68 | 8 | M | Sophomore | blue | 1 | 9.00 | 4 |
    | 33 | 1990 | TX | 9 | 75 | 7 | M | Senior | silver | 5 | 54.00 | 7 |
    | 36 | 1982 | MI | 10 | 61 | 7 | M | Senior | blue | 6 | 5.00 | 2 |
    | 36 | 1996 | TX | 7 | 66 | 5 | M | Freshman | orange | 3 | 7.00 | 3 |
    | 36 | 1990 | IL | 12 | 61 | 7 | M | Junior | red | 4 | 14.00 | 3 |
    | 36 | 1988 | OR | 9 | 73 | 7 | M | Sophomore | blue | 5 | 23.00 | 5 |
    | 40 | 1987 | IL | 10 | 68 | 6 | M | Sophomore | silver | 5 | 16.00 | 5 |
    | 42 | 1962 | IL | 8 | 65 | 6 | F | Junior | red | 4 | 4.00 | 4 |
    | 54 | 1968 | FL | 9 | 70 | 8 | F | Freshman | green | 2 | 5.00 | 3 |
    | 54 | 1970 | NV | 11 | 65 | 4 | F | Freshman | silver | 5 | 54.00 | 7 |
    | 55 | 1997 | OH | 9 | 67 | 6 | F | Freshman | dark blue | 4 | 27.00 | 2 |
    | 63 | 1990 | PA | 10 | 66 | 8 | F | Sophomore | silver | 3 | 5.00 | 7 |
    | 63 | 1986 | MI | 5 | 69 | 7 | F | Sophomore | orange | 3 | 9.00 | 2 |
    | 71 | 1984 | MI | 11 | 64 | 6 | F | Freshman | silver | 2 | 1.00 | 2 |
    | 73 | 1968 | FL | 12 | 70 | 7 | F | Junior | green | 4 | 15.00 | 3 |
    | 73 | 1987 | SC | 11 | 68 | 7 | F | Junior | red | 2 | 18.00 | 5 |
    | 76 | 1985 | PA | 11 | 70 | 8 | F | Sophomore | blue | 3 | 5.00 | 4 |
    | 76 | 1992 | NY | 9 | 65 | 7 | F | Freshman | red | 6 | 7.00 | 2 |
    | 76 | 1990 | PA | 11 | 63 | 4 | M | Sophomore | silver | 5 | 13.00 | 5 |
    | 76 | 1991 | NY | 9 | 63 | 6 | M | Sophomore | silver | 4 | 38.00 | 2 |
    | 78 | 1995 | CA | 11 | 63 | 6 | M | Junior | blue | 2 | 47.00 | 2 |
    | 80 | 1989 | NV | 12 | 69 | 8 | M | Senior | white | 4 | 3.00 | 4 |
    | 80 | 1990 | SC | 10 | 63 | 8 | F | Senior | black | 2 | 7.00 | 7 |
    | 80 | 1999 | FL | 9 | 66 | 7 | F | Freshman | black | 5 | 22.00 | 2 |
    | 88 | 1998 | SC | 6 | 63 | 5 | F | Freshman | black | 3 | 43.00 | 6 |
    | 94 | 1983 | KY | 11 | 74 | 8 | M | Sophomore | red | 3 | 20.00 | 4 |

    ## Sheet1

    |
    |

    **## math1342_database3.xlsx**

    ## MATH399 Data Sheet

    | | | | | | | | | | | | |
    | — | — | — | — | — | — | — | — | — | — | — | — |
    | Drive (miles) | Birth Year | State | Shoe Size | Height (inches) | Sleep (hours) | Gender | Class Standing | Car Color | TV (hours) | Money (dollars) | Coin |
    | 4 | 1988 | NY | 9 | 69 | 7 | F | Sophomore | blue | 5 | 21.00 | 5 |
    | 6 | 1990 | OR | 13 | 75 | 10 | M | Junior | silver | 6 | 7.00 | 4 |
    | 6 | 1978 | MI | 10 | 66 | 6 | M | Freshman | black | 5 | 34.00 | 3 |
    | 20 | 1977 | IL | 5 | 62 | 7 | F | Junior | black | 3 | 10.00 | 2 |
    | 20 | 1985 | OR | 7 | 65 | 4 | F | Sophomore | green | 1 | 46.00 | 4 |
    | 25 | 1988 | CA | 8 | 69 | 6 | F | Senior | silver | 4 | 30.00 | 4 |
    | 25 | 1995 | GA | 9 | 63 | 7 | M | Junior | silver | 3 | 53.00 | 5 |
    | 28 | 1992 | NY | 7 | 67 | 4 | F | Freshman | black | 1 | 25.00 | 4 |
    | 29 | 1990 | TX | 11 | 70 | 7 | M | Freshman | silver | 2 | 28.00 | 3 |
    | 33 | 1985 | SC | 11 | 68 | 8 | M | Sophomore | blue | 1 | 9.00 | 4 |
    | 33 | 1990 | TX | 9 | 75 | 7 | M | Senior | silver | 5 | 54.00 | 7 |
    | 36 | 1982 | MI | 10 | 61 | 7 | M | Senior | blue | 6 | 5.00 | 2 |
    | 36 | 1996 | TX | 7 | 66 | 5 | M | Freshman | orange | 3 | 7.00 | 3 |
    | 36 | 1990 | IL | 12 | 61 | 7 | M | Junior | red | 4 | 14.00 | 3 |
    | 36 | 1988 | OR | 9 | 73 | 7 | M | Sophomore | blue | 5 | 23.00 | 5 |
    | 40 | 1987 | IL | 10 | 68 | 6 | M | Sophomore | silver | 5 | 16.00 | 5 |
    | 42 | 1962 | IL | 8 | 65 | 6 | F | Junior | red | 4 | 4.00 | 4 |
    | 54 | 1968 | FL | 9 | 70 | 8 | F | Freshman | green | 2 | 5.00 | 3 |
    | 54 | 1970 | NV | 11 | 65 | 4 | F | Freshman | silver | 5 | 54.00 | 7 |
    | 55 | 1997 | OH | 9 | 67 | 6 | F | Freshman | dark blue | 4 | 27.00 | 2 |
    | 63 | 1990 | PA | 10 | 66 | 8 | F | Sophomore | silver | 3 | 5.00 | 7 |
    | 63 | 1986 | MI | 5 | 69 | 7 | F | Sophomore | orange | 3 | 9.00 | 2 |
    | 71 | 1984 | MI | 11 | 64 | 6 | F | Freshman | silver | 2 | 1.00 | 2 |
    | 73 | 1968 | FL | 12 | 70 | 7 | F | Junior | green | 4 | 15.00 | 3 |
    | 73 | 1987 | SC | 11 | 68 | 7 | F | Junior | red | 2 | 18.00 | 5 |
    | 76 | 1985 | PA | 11 | 70 | 8 | F | Sophomore | blue | 3 | 5.00 | 4 |
    | 76 | 1992 | NY | 9 | 65 | 7 | F | Freshman | red | 6 | 7.00 | 2 |
    | 76 | 1990 | PA | 11 | 63 | 4 | M | Sophomore | silver | 5 | 13.00 | 5 |
    | 76 | 1991 | NY | 9 | 63 | 6 | M | Sophomore | silver | 4 | 38.00 | 2 |
    | 78 | 1995 | CA | 11 | 63 | 6 | M | Junior | blue | 2 | 47.00 | 2 |
    | 80 | 1989 | NV | 12 | 69 | 8 | M | Senior | white | 4 | 3.00 | 4 |
    | 80 | 1990 | SC | 10 | 63 | 8 | F | Senior | black | 2 | 7.00 | 7 |
    | 80 | 1999 | FL | 9 | 66 | 7 | F | Freshman | black | 5 | 22.00 | 2 |
    | 88 | 1998 | SC | 6 | 63 | 5 | F | Freshman | black | 3 | 43.00 | 6 |
    | 94 | 1983 | KY | 11 | 74 | 8 | M | Sophomore | red | 3 | 20.00 | 4 |

    ## Sheet1

    |
    |

    **## chapter6excelassignment.docx**

    1.

    Top of Form

    Again, you will use the student survey from the Excel spreadsheet given at the beginning of the course:
    [MATH 1342 Database.xlsx](https://content.ctcd.edu/courses/math1342-lec/m23/docs/math1342_database.xlsx)

    Find two free cells in the spreadsheet to enter the appropriate formulas to find the mean and standard deviation of the DRIVE variable by using
    **=AVERAGE(A2:A36)** and =
    **STDEV(A2:A36)**.

    (Round your answers to 5 decimal places)

    Fill in the blank:

    The
    **mean** of the DRIVE variable is
    **Blank 1**.

    The
    **standard deviation** of the DRIVE variable is
    **Blank 2**.

    · Blank 1

    · Blank 2

    Bottom of Form

    2.

    Top of Form

    Question 2

    **Question 2**

    **2 Points**

    Question 2

    Assuming that this variable is normally distributed, what proportion of the data would you predict to be less than 40 minutes? This would be based on the calculated probability.

    To approximate this probability with Excel, find a free cell on the spreadsheet and use the formula
    **=NORM.DIST(40,mean,stdev,TRUE)**. For the "mean" and "stdev" in the formula, you
    _don't_ want to type those words, you want to actually enter the cell numbers in which you just found the average and standard deviation of your DRIVE variable.

    (Keep your answer in decimal form and round your answer to 3 decimal places)

    **Fill in the Blank:** The proportion of values that I expect to be less than 40 minutes is _____________.

    **Blank 1**

    · Blank 1

    Bottom of Form

    3.

    Top of Form

    Question 3

    **Question 3**

    **2 Points**

    Question 3

    Now, determine the
    **_actual_** proportion of data points in the dataset that fall within this range (less than 40 minutes). To find the actual proportion, sort the DRIVE variable, and count how many of the data points are less than 40. Then, divide that number by the total of 35 data points.

    (Keep your answer in decimal form and round your answer to 3 decimal places)

    **Fill in the Blank:** The actual proportion of values less than 40 minutes is ___________.

    **Blank 1**

    · Blank 1

    Bottom of Form

    4.

    Top of Form

    Question 4

    **Question 4**

    **2 Points**

    Question 4

    How does your predicted probability from question 2 compare to the actual probability calculated in question 3? In other words, if these values are different, why do you think they're different, etc?

    Option A

    The probability calculations are different. In part 2, we calculated the probability based on the assumption that the distribution of the "drive" variable is normally distributed. If the distribution is not bell-shaped, then the probability estimation (in part 2) would not be accurate.

    Option B

    The probability calculations are the same.

    Option C

    The probability calculations are different. This must mean that something is wrong with our technology.

    Bottom of Form

    **## math1342_database3.xlsx**

    ## MATH399 Data Sheet

    | | | | | | | | | | | | |
    | — | — | — | — | — | — | — | — | — | — | — | — |
    | Drive (miles) | Birth Year | State | Shoe Size | Height (inches) | Sleep (hours) | Gender | Class Standing | Car Color | TV (hours) | Money (dollars) | Coin |
    | 4 | 1988 | NY | 9 | 69 | 7 | F | Sophomore | blue | 5 | 21.00 | 5 |
    | 6 | 1990 | OR | 13 | 75 | 10 | M | Junior | silver | 6 | 7.00 | 4 |
    | 6 | 1978 | MI | 10 | 66 | 6 | M | Freshman | black | 5 | 34.00 | 3 |
    | 20 | 1977 | IL | 5 | 62 | 7 | F | Junior | black | 3 | 10.00 | 2 |
    | 20 | 1985 | OR | 7 | 65 | 4 | F | Sophomore | green | 1 | 46.00 | 4 |
    | 25 | 1988 | CA | 8 | 69 | 6 | F | Senior | silver | 4 | 30.00 | 4 |
    | 25 | 1995 | GA | 9 | 63 | 7 | M | Junior | silver | 3 | 53.00 | 5 |
    | 28 | 1992 | NY | 7 | 67 | 4 | F | Freshman | black | 1 | 25.00 | 4 |
    | 29 | 1990 | TX | 11 | 70 | 7 | M | Freshman | silver | 2 | 28.00 | 3 |
    | 33 | 1985 | SC | 11 | 68 | 8 | M | Sophomore | blue | 1 | 9.00 | 4 |
    | 33 | 1990 | TX | 9 | 75 | 7 | M | Senior | silver | 5 | 54.00 | 7 |
    | 36 | 1982 | MI | 10 | 61 | 7 | M | Senior | blue | 6 | 5.00 | 2 |
    | 36 | 1996 | TX | 7 | 66 | 5 | M | Freshman | orange | 3 | 7.00 | 3 |
    | 36 | 1990 | IL | 12 | 61 | 7 | M | Junior | red | 4 | 14.00 | 3 |
    | 36 | 1988 | OR | 9 | 73 | 7 | M | Sophomore | blue | 5 | 23.00 | 5 |
    | 40 | 1987 | IL | 10 | 68 | 6 | M | Sophomore | silver | 5 | 16.00 | 5 |
    | 42 | 1962 | IL | 8 | 65 | 6 | F | Junior | red | 4 | 4.00 | 4 |
    | 54 | 1968 | FL | 9 | 70 | 8 | F | Freshman | green | 2 | 5.00 | 3 |
    | 54 | 1970 | NV | 11 | 65 | 4 | F | Freshman | silver | 5 | 54.00 | 7 |
    | 55 | 1997 | OH | 9 | 67 | 6 | F | Freshman | dark blue | 4 | 27.00 | 2 |
    | 63 | 1990 | PA | 10 | 66 | 8 | F | Sophomore | silver | 3 | 5.00 | 7 |
    | 63 | 1986 | MI | 5 | 69 | 7 | F | Sophomore | orange | 3 | 9.00 | 2 |
    | 71 | 1984 | MI | 11 | 64 | 6 | F | Freshman | silver | 2 | 1.00 | 2 |
    | 73 | 1968 | FL | 12 | 70 | 7 | F | Junior | green | 4 | 15.00 | 3 |
    | 73 | 1987 | SC | 11 | 68 | 7 | F | Junior | red | 2 | 18.00 | 5 |
    | 76 | 1985 | PA | 11 | 70 | 8 | F | Sophomore | blue | 3 | 5.00 | 4 |
    | 76 | 1992 | NY | 9 | 65 | 7 | F | Freshman | red | 6 | 7.00 | 2 |
    | 76 | 1990 | PA | 11 | 63 | 4 | M | Sophomore | silver | 5 | 13.00 | 5 |
    | 76 | 1991 | NY | 9 | 63 | 6 | M | Sophomore | silver | 4 | 38.00 | 2 |
    | 78 | 1995 | CA | 11 | 63 | 6 | M | Junior | blue | 2 | 47.00 | 2 |
    | 80 | 1989 | NV | 12 | 69 | 8 | M | Senior | white | 4 | 3.00 | 4 |
    | 80 | 1990 | SC | 10 | 63 | 8 | F | Senior | black | 2 | 7.00 | 7 |
    | 80 | 1999 | FL | 9 | 66 | 7 | F | Freshman | black | 5 | 22.00 | 2 |
    | 88 | 1998 | SC | 6 | 63 | 5 | F | Freshman | black | 3 | 43.00 | 6 |
    | 94 | 1983 | KY | 11 | 74 | 8 | M | Sophomore | red | 3 | 20.00 | 4 |

    ## Sheet1

    |
    |

    **## chapter6excelassignment.docx**

    1.

    Top of Form

    Again, you will use the student survey from the Excel spreadsheet given at the beginning of the course:
    [MATH 1342 Database.xlsx](https://content.ctcd.edu/courses/math1342-lec/m23/docs/math1342_database.xlsx)

    Find two free cells in the spreadsheet to enter the appropriate formulas to find the mean and standard deviation of the DRIVE variable by using
    **=AVERAGE(A2:A36)** and =
    **STDEV(A2:A36)**.

    (Round your answers to 5 decimal places)

    Fill in the blank:

    The
    **mean** of the DRIVE variable is
    **Blank 1**.

    The
    **standard deviation** of the DRIVE variable is
    **Blank 2**.

    · Blank 1

    · Blank 2

    Bottom of Form

    2.

    Top of Form

    Question 2

    **Question 2**

    **2 Points**

    Question 2

    Assuming that this variable is normally distributed, what proportion of the data would you predict to be less than 40 minutes? This would be based on the calculated probability.

    To approximate this probability with Excel, find a free cell on the spreadsheet and use the formula
    **=NORM.DIST(40,mean,stdev,TRUE)**. For the "mean" and "stdev" in the formula, you
    _don't_ want to type those words, you want to actually enter the cell numbers in which you just found the average and standard deviation of your DRIVE variable.

    (Keep your answer in decimal form and round your answer to 3 decimal places)

    **Fill in the Blank:** The proportion of values that I expect to be less than 40 minutes is _____________.

    **Blank 1**

    · Blank 1

    Bottom of Form

    3.

    Top of Form

    Question 3

    **Question 3**

    **2 Points**

    Question 3

    Now, determine the
    **_actual_** proportion of data points in the dataset that fall within this range (less than 40 minutes). To find the actual proportion, sort the DRIVE variable, and count how many of the data points are less than 40. Then, divide that number by the total of 35 data points.

    (Keep your answer in decimal form and round your answer to 3 decimal places)

    **Fill in the Blank:** The actual proportion of values less than 40 minutes is ___________.

    **Blank 1**

    · Blank 1

    Bottom of Form

    4.

    Top of Form

    Question 4

    **Question 4**

    **2 Points**

    Question 4

    How does your predicted probability from question 2 compare to the actual probability calculated in question 3? In other words, if these values are different, why do you think they're different, etc?

    Option A

    The probability calculations are different. In part 2, we calculated the probability based on the assumption that the distribution of the "drive" variable is normally distributed. If the distribution is not bell-shaped, then the probability estimation (in part 2) would not be accurate.

    Option B

    The probability calculations are the same.

    Option C

    The probability calculations are different. This must mean that something is wrong with our technology.

    Bottom of Form

    **## math1342_database3.xlsx**

    ## MATH399 Data Sheet

    | | | | | | | | | | | | |
    | — | — | — | — | — | — | — | — | — | — | — | — |
    | Drive (miles) | Birth Year | State | Shoe Size | Height (inches) | Sleep (hours) | Gender | Class Standing | Car Color | TV (hours) | Money (dollars) | Coin |
    | 4 | 1988 | NY | 9 | 69 | 7 | F | Sophomore | blue | 5 | 21.00 | 5 |
    | 6 | 1990 | OR | 13 | 75 | 10 | M | Junior | silver | 6 | 7.00 | 4 |
    | 6 | 1978 | MI | 10 | 66 | 6 | M | Freshman | black | 5 | 34.00 | 3 |
    | 20 | 1977 | IL | 5 | 62 | 7 | F | Junior | black | 3 | 10.00 | 2 |
    | 20 | 1985 | OR | 7 | 65 | 4 | F | Sophomore | green | 1 | 46.00 | 4 |
    | 25 | 1988 | CA | 8 | 69 | 6 | F | Senior | silver | 4 | 30.00 | 4 |
    | 25 | 1995 | GA | 9 | 63 | 7 | M | Junior | silver | 3 | 53.00 | 5 |
    | 28 | 1992 | NY | 7 | 67 | 4 | F | Freshman | black | 1 | 25.00 | 4 |
    | 29 | 1990 | TX | 11 | 70 | 7 | M | Freshman | silver | 2 | 28.00 | 3 |
    | 33 | 1985 | SC | 11 | 68 | 8 | M | Sophomore | blue | 1 | 9.00 | 4 |
    | 33 | 1990 | TX | 9 | 75 | 7 | M | Senior | silver | 5 | 54.00 | 7 |
    | 36 | 1982 | MI | 10 | 61 | 7 | M | Senior | blue | 6 | 5.00 | 2 |
    | 36 | 1996 | TX | 7 | 66 | 5 | M | Freshman | orange | 3 | 7.00 | 3 |
    | 36 | 1990 | IL | 12 | 61 | 7 | M | Junior | red | 4 | 14.00 | 3 |
    | 36 | 1988 | OR | 9 | 73 | 7 | M | Sophomore | blue | 5 | 23.00 | 5 |
    | 40 | 1987 | IL | 10 | 68 | 6 | M | Sophomore | silver | 5 | 16.00 | 5 |
    | 42 | 1962 | IL | 8 | 65 | 6 | F | Junior | red | 4 | 4.00 | 4 |
    | 54 | 1968 | FL | 9 | 70 | 8 | F | Freshman | green | 2 | 5.00 | 3 |
    | 54 | 1970 | NV | 11 | 65 | 4 | F | Freshman | silver | 5 | 54.00 | 7 |
    | 55 | 1997 | OH | 9 | 67 | 6 | F | Freshman | dark blue | 4 | 27.00 | 2 |
    | 63 | 1990 | PA | 10 | 66 | 8 | F | Sophomore | silver | 3 | 5.00 | 7 |
    | 63 | 1986 | MI | 5 | 69 | 7 | F | Sophomore | orange | 3 | 9.00 | 2 |
    | 71 | 1984 | MI | 11 | 64 | 6 | F | Freshman | silver | 2 | 1.00 | 2 |
    | 73 | 1968 | FL | 12 | 70 | 7 | F | Junior | green | 4 | 15.00 | 3 |
    | 73 | 1987 | SC | 11 | 68 | 7 | F | Junior | red | 2 | 18.00 | 5 |
    | 76 | 1985 | PA | 11 | 70 | 8 | F | Sophomore | blue | 3 | 5.00 | 4 |
    | 76 | 1992 | NY | 9 | 65 | 7 | F | Freshman | red | 6 | 7.00 | 2 |
    | 76 | 1990 | PA | 11 | 63 | 4 | M | Sophomore | silver | 5 | 13.00 | 5 |
    | 76 | 1991 | NY | 9 | 63 | 6 | M | Sophomore | silver | 4 | 38.00 | 2 |
    | 78 | 1995 | CA | 11 | 63 | 6 | M | Junior | blue | 2 | 47.00 | 2 |
    | 80 | 1989 | NV | 12 | 69 | 8 | M | Senior | white | 4 | 3.00 | 4 |
    | 80 | 1990 | SC | 10 | 63 | 8 | F | Senior | black | 2 | 7.00 | 7 |
    | 80 | 1999 | FL | 9 | 66 | 7 | F | Freshman | black | 5 | 22.00 | 2 |
    | 88 | 1998 | SC | 6 | 63 | 5 | F | Freshman | black | 3 | 43.00 | 6 |
    | 94 | 1983 | KY | 11 | 74 | 8 | M | Sophomore | red | 3 | 20.00 | 4 |

    ## Sheet1

    |
    |

    – 1
    – 2

  • [Solved] Prof Double R

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    ## Scenario You have been hired by the Regional Real Estate Company to help them analyze real estate data. One of the company’s Pacific region salespeople is working to design a new advertisement. The initial draft of the advertisement states that the average cost per square foot of home sales in th…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    ## Scenario
    You have been hired by the Regional Real Estate Company to help them analyze real estate data. One of the company’s Pacific region salespeople is working to design a new advertisement. The initial draft of the advertisement states that the average cost per square foot of home sales in the Pacific region is $280. The salesperson claims that the average cost per square foot in the Pacific region is less than $280.  He wants you to make sure he can make that statement (that the average cost per square foot is less than $280) before asking for the advertisement text to be changed. In order to test his claim, you will generate a random sample size of 750 using data for the Pacific region and use this data to perform a hypothesis test.
    ## Prompt
    Generate a sample of size 750 houses using data for the Pacific region. Then, design a hypothesis test and interpret the results using significance level α = .05. You will work with this sample in this assignment. Briefly describe how you generated your random sample.
    Use the [House Listing Price by Region](https://learn.snhu.edu/content/enforced/1923642-MAT-240-17909.202551-1/course_documents/MAT%20240%20House%20Listing%20Price%20by%20Region.xlsx?ou=1923642) document to help support your work on this assignment. You may also use the [Descriptive Statistics in Excel PDF](https://learn.snhu.edu/content/enforced/1923642-MAT-240-17909.202551-1/course_documents/MAT%20240%20Descriptive%20Statistics%20in%20Excel.pdf?isCourseFile=true&ou=1923642) and [Creating Histograms in Excel PDF](https://learn.snhu.edu/content/enforced/1923642-MAT-240-17909.202551-1/course_documents/MAT%20240%20Creating%20Histograms%20in%20Excel.pdf?ou=1923642) tutorials for support.
    Specifically, you must address the following rubric criteria, using the [Module Five Assignment Template Word Document](https://learn.snhu.edu/content/enforced/1923642-MAT-240-17909.202551-1/course_documents/MAT%20240%20Module%20Five%20Assignment%20Template.docx?isCourseFile=true&ou=1923642)
    – **Introduction:** Describe the purpose of this analysis and how you generated your random sample size of 750 houses.
    – **Hypothesis Test Setup:**Define your population parameter, including hypothesis statements, and specify the appropriate test.
    – Define your population parameter.
    – Write the null and alternative hypotheses.
    – Specify the name of the test you will use.
    – Identify whether it is a left-tailed, right-tailed, or two-tailed test.
    – **Data Analysis Preparations:**Describe sample summary statistics, provide a histogram and summary, check assumptions, and identify the test significance level.
    – Provide the descriptive statistics (sample size, mean, median, and standard deviation).
    – Provide a histogram of your sample.
    – Summarize your sample by writing a sentence describing the shape, center, and spread of your sample.
    – Check whether the assumptions to perform your identified test have been met.
    – Identify the test significance level. For example, α = .05.
    – **Calculations:** Calculate the _p_ value, describe the _p_ value and test statistic in regard to the normal curve graph, discuss how the p value relates to the significance level, and compare the _p_ value to the significance level to reject or fail to reject the null hypothesis.
    – Calculate the sample mean and standard error.
    – Determine the appropriate test statistic, then calculate the test statistic.
    – **Note:** This calculation is (mean – target)/standard error. In this case, the mean is your regional mean (Pacific), and the target is 280.
    – Calculate the _p_ value using one of the following tests.
    – **Choose your test from the following:**
    – **=T.DIST.RT([test statistic], [degree of freedom])**: right-tailed test
    – **=T.DIST([test statistic], [degree of freedom], 1)**: left-tailed test
    – **=T.DIST.2T([test statistic], [degree of freedom])**: two-tailed test
    – **Note:** The degree of freedom is calculated by subtracting 1 from your sample size.
    – Using the normal curve graph as a reference, describe where the p value and test statistic would be placed.
    – **Test Decision:**Compare the relationship between the p value and the significance level, and decide to reject or fail to reject the null hypothesis.
    – Compare the relationship between the _p_ value and significance level.
    – Decide to reject or fail to reject the null hypothesis.
    – **Conclusion:**Discuss how your test relates to the hypothesis and discuss the statistical significance.
    – Explain in one paragraph how your test decision relates to your hypothesis and whether your conclusions are statistically significant.
    ## What to Submit
    Submit your completed Module Five Assignment Template as a Word document that includes your response, supporting charts/graphs, and your Excel file.
    \
    MAT240ModuleFiveAssignmentTemplate.docx](https://www.sweetstudy.com/files/mat240modulefiveassignmenttemplate-docx-10310927 "MAT240ModuleFiveAssignmentTemplate.docx")
    \
    MAT240HouseListingPricebyRegion.xlsx](https://www.sweetstudy.com/files/mat240houselistingpricebyregion-xlsx-10310929 "MAT240HouseListingPricebyRegion.xlsx")

  • [Solved] MAT-274 Inferential Statistics

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    You suspect that among fraternal twins born across the United States, the second-born twin has a higher resting heart rate from ages 0-2 years. Your instructor will provide an Excel sheet containing resting heart rate data (in beats per minute) for 129 pairs of fraternal twins, measured at age 1 yea…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    You suspect that among fraternal twins born across the United States, the second-born twin has a higher resting heart rate from ages 0-2 years. Your instructor will provide an Excel sheet containing resting heart rate data (in beats per minute) for 129 pairs of fraternal twins, measured at age 1 year. You will be addressing the following areas, including relevant calculations and explanations; see the assignment style guide for details about what to consider in your responses:
    (1)Consider how your data is obtained.
    (2)Select an appropriate hypothesis test.
    (3)Describe your hypothesis in mathematical and nonmathematical terms.
    (4)Using your Excel sample data, complete the relevant hypothesis test calculations.
    (5)Make a formal decision on your null hypothesis.
    (6)Using your Excel sample data, complete the relevant confidence interval calculations.
    (7)Discuss how to interpret your confidence interval.
    (8)Consider the effects of increasing the sample size.
    (9)Consider confounding variables
    \
    MAT-274-RS-InferentialStatisticsProject-FA24.docx](https://www.sweetstudy.com/files/mat-274-rs-inferentialstatisticsproject-fa24-docx-10308227 "MAT-274-RS-InferentialStatisticsProject-FA24.docx")
    \
    MAT-274-RS-InferentialStyleGuide-FA24.docx](https://www.sweetstudy.com/files/mat-274-rs-inferentialstyleguide-fa24-docx-10308229 "MAT-274-RS-InferentialStyleGuide-FA24.docx")
    \
    4-14MAT274ProjectData.xlsx](https://www.sweetstudy.com/files/4-14mat274projectdata-xlsx-10308231 "4-14MAT274ProjectData.xlsx")