· For each question submit an image or pdf of your solution. Each question is to be uploaded separately and each will accept multiple files.· When the assignment is completed, press Submit at the...

1 answer below »
Find the attached files.


· For each question submit an image or pdf of your solution. Each question is to be uploaded separately and each will accept multiple files. · When the assignment is completed, press Submit at the end of the page · Do not round any number during calculating, always use the exact number till you get the final answer Excel Hint for finding critical values: · Two tailed t test · Left tailed t test or right tailed t test 1. A group of 8 students are asked to estimate the length of one minute without reference to any timers. The times they provided (in seconds) are given below: 53 67 63 55 75 58 56 62 Assuming the population is approximately normal and using a 0.05 significance level, test the claim that these provided times are indeed from a population with mean 60 seconds. a) State the null and alternative hypotheses. b) Calculate the test statistic (round it to 3 decimal places). c) Find the critical value (round it to 3 decimal places). d) Make a statistical conclusion. Do the results indicate that students are reasonably good at estimating the length of one minute? 2. A professor claims that the mean final mark for is greater than 65. A sample of 35 students shows the sample mean is 67 with standard deviation 15. Test the professor’s claim using a 0.05 significance level. a) State the null and alternative hypotheses. b) Calculate the test statistic (round it to 3 decimal places). c) Find the P -value (round it to 3 decimal places). d) Make a conclusion based on your answers in parts b) and c). e) Explain what would constitute a Type I error in this context. f) Explain what would constitute a Type II error in this context. 3. The data in the table below were obtained through a survey of randomly selected individuals in London Speeding Tickets Received Within the Last Year? Yes No Male 30 224 Female 27 473 a) Find the probability of getting someone ticketed for speeding, given that the selected person is a man (round to 3 decimal places). b) Find the probability of getting someone ticketed for speeding, given that the selected person is a woman (round to 3 decimal places). c) Use a 0.01 level of significance to test the claim that men are more likely to receive a speeding ticket than women. · To use normal approximation, check the sample size requirements · Calculate the test statistics (round to 3 decimal places). d) Find the critical value (round it to 3 decimal places). e) Make a conclusion based on your answer from part c) and d). 4. 10 Healthy adults’ initial temperature (Temp 1) have been measured while sitting still, then their temperatures are measured again after laying down (Temp 2). Subject 1 2 3 4 5 6 7 8 9 10 11 Temp 1 37.51 37.07 37.20 37.23 37.38 37.59 37.28 37.12 37.55 37.04 37.78 Temp 2 37.17 36.91 36.70 36.80 36.96 37.25 37.11 36.82 37.36 36.92 37.22 a) To test the claim that the mean temperature difference is 0 while sitting still vs. laying down, state the null and alternative hypotheses. b) At significance level, find the critical value (round to 3 decimal places). c) Calculate the test statistics (round to 3 decimal places). d) Use Excel Data Analysis function, at 0.05 significance level, compare the two paired sample mean, submit a screenshot of the result output. (t Stat from the output should match your answer in part c). e) Based on your answer from c) or d), at level, what is your conclusion? 5. Download the excel file “Births” for the data set. It uses the birth weights of boys and girls. Using Excel Data Analysis Tool, test the claim that girls have a lower mean weight than boys at 0.05 level of significance. Do not assume population variances are equal. Hint: Open Excel, Data – Data Analysis. See two pictures below. a) State the null and alternative hypotheses. b) Find the test statistic (round it to 3 decimal places) from Excel output c) Find the P -value (round it to 3 decimal places) from Excel output d) Find critical value from Excel output e) Make a statistical conclusion based on your answers in parts b) to d). 6. An agent for a real estate company wanted to predict the monthly rent for apartments based on the size of the apartment. The data ”Rent” for a sample of 25 apartments is available for download from Brightspace. Perform a t test for the slope to determine if a significant linear relationship between the size and the rent exists at the 0.05 level of significance. a) Create a scatter plot using Excel. Using your official name as the chart title. b) Use Excel CORREL to find the linear correlation coefficient r. c) Find test statistic from Excel Summary Output. d) Find p-value from Excel Summary Output e) Make a statistical conclusion based on your answers in parts c) and d). Note 1, for c) and d), please submit your Excel Summary Output. Note 2, hint for using Regression using Excel: Girls Girl BIRTH WEIGHTBoy BIRTH WEIGHT 35003900 8002800 24003700 42004000 31003400 20001600 29003500 33003900 28003000 25003200 40003300 3100300 30004000 34004500 35003600 15001700 16003900 9003800 38002200 21001800 26003500 43003400 34003000 33004100 35004100 30002700 35002900 29003300 33002800 25003500 28003700 28003600 35003300 9003700 27004300 37002600 35003300 30003200 34003900 47003600 33003400 28004100 33003300 31001500 24002600 42003300 32003600 23003800 29002000 31003000 27003800 42003600 35003100 30001500 4000600 36001000 32003200 35003800 24003900 31003600 28003400 38003200 25003600 31003400 35003600 37002700 35003500 43003600 25003400 31003800 38003400 28003400 30002700 36002900 27004100 33004300 27003500 37003100 32003400 38003600 28003800 36002800 25004900 26003800 32003600 26003000 33003200 33003700 29003400 29004000 31003900 30002500 19002800 31003300 31002900 43003700 32003300 18003600 32003100 30003300 30003500 32002700 33003700 31004000 32003700 26002300 38002900 32003300 34002600 23002400 35003300 26003200 31003800 28002900 33003400 30003300 32002700 34003300 23003000 29002900 28003900 19004000 36002900 36003500 41003700 22003500 38003800 30003600 31004000 26003200 34003600 20004100 31003500 36003400 17003300 33003100 33004000 37003200 34002700 31003200 38003100 26003500 36003700 36003400 30003600 28003600 29003000 36003100 23003500 3002900 33003600 33003300 34003000 28003300 34004000 18002700 24003400 28002900 29002800 27003400 33002300 29002900 36002400 36003600 46003500 31003500 7003800 26002700 20004000 33002300 20003600 37004500 31003300 36002700 16002600 30003700 27001600 32003900 40003100 34004600 38002500 37003600 34003400 33003200 24002800 36002800 22004300 31003300 28002800 37002900 34003300 31003500 32003200 24003400 8003200 2400 3500 1700 3000 3500 2900 3400 4000 3200 4000 Sheet1 Size_(sq._ft)Rent_($) 8401975 14402650 10852175 12422500 7281975 14952700 11262675 7361935 6901900 9662125 11102400 12852625 19753275 13692800 11652400 12352475 12352075 12492700 11502200 9062175 13612600 10302675 7652175 9901800 12002750
Answered 1 days AfterMar 19, 2023

Answer To: · For each question submit an image or pdf of your solution. Each question is to be uploaded...

Radhika answered on Mar 20 2023
35 Votes
· For each question submit an image or pdf of your solution. Each question is to be uploaded separately and each will accept multiple files.
· When the assignment is completed, press Submit at the end of the page
· Do not round any number duri
ng calculating, always use the exact number till you get the final answer
Excel Hint for finding critical values:
· Two tailed t test
· Left tailed t test or right tailed t test
1. A group of 8 students are asked to estimate the length of one minute without reference to any timers. The times they provided (in seconds) are given below:
    53
    67
    63
    55
    75
    58
    56
    62
Assuming the population is approximately normal and using a 0.05 significance level, test the claim that these provided times are indeed from a population with mean 60 seconds.
a) State the null and alternative hypotheses.
b) Calculate the test statistic (round it to 3 decimal places).
c) Find the critical value (rounditto3decimalplaces).
d) Make a statistical conclusion.Do the results indicate that students are reasonably good at estimating the length of one minute?
Solution 1 : Pop ~ Normal (60, 1)
a) Null Hypothesis H0: Mean of time length is 60 seconds i.e., μ = 60
Alternative Hypothesis H1: μ ≠ 60
b) Test Statistic : Since the sample size is small, so we use t test for difference of means.
Test Statistic :

c) Critical value : 23.752
d) Since the p value of the test statistic is less than 0.05 so we may reject H0 at 5% level of significance. Also the critical value t(0.05, 7) = 2.364 , which is less than the test statistic. Thus we cannot fix the sample mean at 60 seconds. It further indicates that the students results are reasonably not enough to estimate the length of one minute.
2. Aprofessorclaimsthatthemeanfinal mark forisgreaterthan65.Asampleof35 students shows the sample mean is 67 with standard deviation 15. Test the professor’s claim using a 0.05 significance level.
a) Statethenullandalternativehypotheses.
b) Calculatetheteststatistic(rounditto3decimalplaces).
c) FindtheP-value(rounditto3decimalplaces).
d) Makeaconclusionbasedonyouranswersinpartsb)andc).
e) ExplainwhatwouldconstituteaTypeIerrorinthiscontext.
f) ExplainwhatwouldconstituteaTypeIIerrorinthiscontext.
Solution 2 :
a) Null Hypothesis H0: μ > 65
Alternative Hypothesis H1: μ < 65
b) Test Statistic : Since the sample size is small, so we use t test for difference of means.
Test Statistic :...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here