Please find the test statistic and the p value. Please show how to do in excel. Thnak you! An important source of income for a large international banking company is home loans. The loan manager at a branch keeps track of the number of loan applicants who visit the branch's loan department per week. Over the last year, the loanmanager accumulated the data shown in the table below. From previous years, the manager believes that the distribution of the number of customers has a Poisson distribution with an average of 3.6 loan applicants per week. Determine if theloan officer's belief is correct using a significance level of 0.05.Number of12426 OCustomersFrequencies1410 1113710State the appropriate null and alternative hypotheses. Choose the correct answer below.O A. Ho: The population mean is equal to 3.6.HA: The population mean is not equal to 3.6.B. Ho: The population is Poisson distributed with mean equal to 3.6.HA: The population is not Poisson distributed with mean equal to 3.6.O C. Ho: The population is not Poisson distributed with mean equal to 3.6.HA: The population is Poisson distributed with mean equal to 3.6.O D. Ho: The population mean is not equal to 3.6.HA: The population mean is equal to 3.6.The test statistic is y =|(Round to three decimal places as needed.)

To find Chi-square test Statistic in excel we enter the given data set in excel sheet. And find…

An important source of income for a large international banking company is home loans. The loan manager at a branch keeps track of the number of loan applicants who visit the branch's loan department per week. Over the last year, the loan manager accumulated the data shown in the table below. From previous years, the manager believes that the distribution of the number of customers has a Poisson distribution loan officer's belief is correct using a significance level of 0.05. an average of 3.6 loan applicants per week. Determine if the Number of Customers 0 1 2 3 4 5 26 Frequencies 1 7 10 4 10 11 13 State the appropriate null and alternative hypotheses. Choose the correct answer below. O A. Ho: The population mean is equal to 3.6. HA: The population mean is not equal to 3.6. B. Ho: The population is Poisson distributed with mean equal to 3.6. HA: The population is not Poisson distributed with mean equal to 3.6. O C. Ho: The population is not Poisson distributed with mean equal to 3.6. HA: The population is Poisson distributed with mean equal to 3.6. O D. Ho: The population mean is not equal to 3.6. HA: The population mean is equal to 3.6. The test statistic is y? =D. (Round to three decimal places as needed.)

An important source of income for a large international banking company is home loans. The loan manager at a branch keeps track of the number of loan applicants who visit the branch's loan department per week. Over the last year, the loan manager accumulated the data shown in the table below. From previous years, the manager believes that the distribution of the number of customers has a Poisson distribution loan officer's belief is correct using a significance level of 0.05. an average of 3.6 loan applicants per week. Determine if the Number of Customers 0 1 2 3 4 5 26 Frequencies 1 7 10 4 10 11 13 State the appropriate null and alternative hypotheses. Choose the correct answer below. O A. Ho: The population mean is equal to 3.6. HA: The population mean is not equal to 3.6. B. Ho: The population is Poisson distributed with mean equal to 3.6. HA: The population is not Poisson distributed with mean equal to 3.6. O C. Ho: The population is not Poisson distributed with mean equal to 3.6. HA: The population is Poisson distributed with mean equal to 3.6. O D. Ho: The population mean is not equal to 3.6. HA: The population mean is equal to 3.6. The test statistic is y? =D. (Round to three decimal places as needed.)

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Find the value of the binomial coefficient, n = 28, x = 3. You may use your calculator or MS Excel. In using MS Excel, follow this procedure. =bin.then click COMBIN..double click.type n, type x. Answer must in whole number. Sample Answer: 98990
I need help finding the median, QI, Q3, IQR, Range. Please!
A group of seven sixth-graders measure and record their heights. The heights (in inches) are shown below. 57, 54, 59, 57, 61, 58, 60 Find the mean and the median of the heights.
How do you do a spearman’s test ranking
On a 5 question multiple choice test there are five possible answers, of which one is correct. Find the mean of the number of questions students guess correctly. Find the standard error of the number of questions guess correctly.
Some students conducted a survey on some people's weekly income: $900, $900, $1300, $1200, $125600, $1200 The mean of these people's weekly income is The median of these people's weekly income is Which number, mean or median, is a better way to represent these people's weekly income? mean median
Contrust a stem and leaf display for the following scores. 30, 23, 58, 28, 35, 67, 27, 42, 46, 35 51, 33, 18, 33, 25, 38, 48, 36, 31, 39
Fewer than 91% of adults have a cell phone. In a reputable poll of 1191 adults, 86% said that they have a cell phone. Find the value of the test statistic. -6.03 -5.02 6.03 -7.56
Help
The data represents the number of points received in a quiz. 9, 9, 10, 10, 10, 1 Mean- 8.166... Median- 9.5 What is a better measure of center? The mean or median and why?
Determine whether the variable is qualitative or quantitative. Favorite TV Show
State the Increasing/Decreasing Test.