statistics and probability questions, solve clearly, show steps and in 30 minutes for thumbs up vote

A government report on remuneration for university administrators in Canada lists average salaries for various executive roles. The total annual salary for university presidents is listed as $500,000. To test this reported figure, at LOC = 95%, a random sample of 16 Canadian university presidents’ total annual salaries was collected. The raw data is below (in $/year):
618,000, 464,000, 686,000, 500,000, 746,000, 704,000, 596,000, 629,000,
523,000, 756,000, 561,000, 608,000, 691,000, 663,000, 529,000, 442,000.
a) Find the mean and standard deviation using a spreadsheet.
b) Assess the government report’s claim, using the critical-value method.
c) Use the p-value method to determine if there are any commonly-used LOC values for which the conclusion would be opposite to your answer from Part (a).

Consider the following set of requirements for a university information system that is used to keep track of students’ transcripts.

R1: The university keeps track of each student's name, student number, class, and degree program.

R2. The university consists of various departments. Each department is described by a name, department code and phone.

R3. Each course has a course number, course name, and credits.

R4. Each section has an instructor, course number, and section number. There might be multiple sections of each course offered in the semester.

The other requirements for this application are:

R5: An administrator can update the courses to be taught by instructors, and enter the list of students taking a course.

R6: An instructor can enter and update the grades of the course(s) taught by this instructor.

R7: A student can request a grade report from the information system.

REQUIRED

1. Create A Use Case Diagram
2. Create A Class Diagram

The British national healthcare system owns many hospitals and directly employs workers. General practitioner salaries are set by the British government. The funding for healthcare services comes mostly from the government. This is significantly different from the US healthcare systems. Consider the issues with government healthcare programs in financing and administration. Address the following:

Would the US be able to transit to the British style of national healthcare? Why or why not?

In comparison to the British system and US system, what would be some of the challenges the US would face in adopting a national healthcare system? Discuss at least three challenges.

Keep between 150-300 words

Assume the age of death for all us burials(of persons over 5 years old) is approximately normally distributed and the sample mean is 68.84 and the standard deviation is 18.402926789.

Find the age at death such that 1.5% of US burials (of persons over 5 years old) were at least that old.

Find the probability that a burial randomly selected from all US burials (of persons over 5 years old) involved a person at least 30 years old.

Find the probability that a burial randomly selected from all US burials ( of persons over 5 years old) involved a person at most 85 years old.

John is looking at several options to fund his son’s 4-year university degree. The university fees of $45,000 a year will have be paid starting 11 years from today. He is analysing an insurance plan that pays out $45,000 a year for 4 years with the first payout 11 years from today. The insurance plan has several payment options:

Option 1 Pay $60,000 today.
Option 2 Beginning 1 year from today, pay $12,000 a year for the next 8 years.
Option 3 Beginning 1 year from today, make payments each year for the next 8 years. The first payment is $11,000 and the amount increases by 5% each year.

Can I have the cash flow time line for these 3 options with regards to calculating present value.

John is looking at several options to fund his son’s 4-year university degree.

The university fees of $45,000 a year will have be paid starting 11 years from today. He is analysing an insurance plan that pays out $45,000 a year for 4 years with the first payout 11 years from today. The insurance plan has several payment options:

Option 1
Pay $60,000 today.

Option 2
Beginning 1 year from today, pay $12,000 a year for the next 8 years.

Option 3

Beginning 1 year from today, make payments each year for the next 8 years. The first payment is $11,000 and the amount increases by 5% each year.

Answer the following questions regarding the options above:

1. (a) Calculate the present value of each option. Use a 10% discount rate.

In​ 1991, a study was conducted to determine the education levels of people who declare bankruptcy. The percentages are shown in the accompanying table. Also shown in the table is the observed frequency for these education levels from a random sample of individuals who files for bankruptcy in 2017. Use these data to complete parts a through c.

Education level Probability 1991​ (%) Observed Frequency 2017

No high school diploma 21.5%    12

High school diploma    30.3%    38

Some college 35.5%    42

College diploma 9.9%    18   

Advanced degree 2.8​%    5

Total ​100% 115

a. Using alpha α=0.05​, perform a​ chi-square test to determine if the probability distribution for the education levels of individuals who files for bankruptcy changed between 1991 and 2017.

What is the null​ hypothesis, H0​?

A. The distribution of education levels is 12 no high school​ diploma, 38 high school​ diploma, 42 some​ college,18 college​ diploma, and 5 advanced degree.

B. The distribution of education levels follows the normal distribution.

C. The distribution of education levels is 21.5​% no high school​ diploma, 30.3​% high school​ diploma, 35.5​% some​ college, 9.9​% college​ diploma, and 2.8​% advanced degree.

D. The distribution of education levels differs from the claimed or expected distribution.

What is the alternative​ hypothesis, H1​?

A. The distribution of education levels differs from the claimed or expected distribution.

B. The distribution of education levels is​ 20% no high school​ diploma, 20% high school​ diploma, 20% some​ college, 20% college​ diploma, and​ 20% advanced degree.

C. The distribution of education levels does not follow the normal distribution.

D. The distribution of education levels is the same as the claimed or expected distribution.

The test​ statistic, combining the College diploma and Advanced degree​ rows, is . ​(Round to two decimal places as​ needed.)

b. Determine the​ p-value using Excel and interpret its meaning.

Identify a function that can be used in Excel to directly calculate the​ p-value (with no other calculations needed other than calculating the arguments of the function​ itself). (=CHISQ.DIST(x, deg_freedom, cumulative)/=NORM.S.DIST(z, cumulative)/ =CHISQ.DIST.RT(x, deg_freedom)/ =T.DIST.2T(x, deg_freedom)/=T.DIST.RT(x, deg_freedom) pick one

Determine the​ p-value, combining the College diploma and Advanced degree rows.

​p-value=nothing ​(Round to three decimal places as​ needed.)

Interpret the​ p-value.

The​ p-value is the probability of observing a test statistic (greater than/less than/equal to) the test​ statistic, assuming (the distribution of the variable is the normal distribution/the expected frequencies are all equal to 5/the distribution of the variable differs from the given distribution/at least one expected frequency differs from 5/the distribution of the variable differs from the normal distribution/the distribution of the variable is the same as the given distribution) pick one.

c. What conclusion can be drawn about the type of individual who filed for bankruptcy in 2017 vs. the type of individual who filed for bankruptcy in​ 1991?

(Reject/ Do not reject) H0. At the 5​% significance​ level, there (is not/is) enough evidence to conclude that the distribution of education levels (is the same as/differs from) the( normal distribution/claimed or expected distribution/uniform distribution.) pick one Click to select your answer(s).

Explain the difference between horizontal and vertical analysis. What does each analysis tell us about a company?

[Red Cross Red Shield] The distribution of the amount paid in health claims by Red Cross Red Shield (RCRS), a medical insurance company, on individual health insurance plans for college students has mean $500, median $400, and standard deviation $550.

Consider the variation of the amount paid of a sample of 40 plan members. Do you think that the standard deviation of the sample mean of participants (Stdev[ ]) is smaller than, larger than, or equal to the standard deviation of individual annual amount paid? Why?