Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department:

Prepare a flexible budget for 14,000, 18,000, and 21,000 filing cabinets for the month of March in the Assembly Department similar to Exhibit 5. Enter all amounts as positive numbers.

Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it produces filing cabinets in two departments: Fabrication and Trim Assembly. Assume the following information for the Fabrication Department:

Prepare a flexible budget for 15,000, 19,000, and 23,000 filing cabinets for the month of October 2016, similar to Exhibit 5, assuming that inventories are not significant. Enter all amounts as positive numbers.

The median incomes of females in each state of the United States, including the District of Columbia and Puerto Rico, are given in following table ("Median income of," 2013). $31,862 $40,550 $36,048 $30,752 $41,817 $40,236 $47,476 $40,500 $60,332 $33,823 $35,438 $37,242 $31,238 $39,150 $34,023 $33,745 $33,269 $32,684 $31,844 $34,599 $48,748 $46,185 $36,931 $40,416 $29,548 $33,865 $31,067 $33,424 $35,484 $41,021 $47,155 $32,316 $42,113 $33,459 $32,462 $35,746 $31,274 $36,027 $37,089 $22,117 $41,412 $31,330 $31,329 $33,184 $35,301 $32,843 $38,177 $40,969 $40,993 $29,688 $35,890 $34,381 Create a histogram and relative frequency histogram for the data in the table using 7 class intervals and answer the following questions:

The estimated average concentration of NO2 in air in the United States in 2006 was 0.016 ppm.

Calculate the partial pressure of the NO2 in a sample of this air when the atmospheric pressure is 748 torr (99.7 kPa ).

How many molecules of NO2 are present under these conditions at 17 ∘C in a room that measures 16 × 11 × 6 ft ?

A prescription drug is produced in the United States and sold internationally.
Each unit of the drug costs $60 to produce. In the German market, you sell the drug for
150 euros per unit. The current exchange rate is 0.667 U.S. dollars per euro. Current
demand for the drug is 100 units, and the estimated elasticity is 2.5. Assuming a linear
demand curve, determine the appropriate sales price (in euros) for the drug. SOLVE USING EXCEL SOLVER. NOTE: aLL PARTS OF THE QUESTION ARE ALREADY INCLUDE HERE. NO EXTRA DATA SHEET.

(a). Now the population is all senior living facilities in the United States. It is conjectured that the mean number of positive COVID-19 cases per 100 residents is 40, and of interest is to test this conjecture versus the alternative that the mean number of positive COVID-19 cases per 100 residents is different from 40. State the appropriate null and alternative hypotheses that should be tested.

(b). Consider the information and hypotheses specified in part (a). A simple random sample of 61 senior living facilities in the United States was selected and the mean number of positive COVID-19 cases per 100 residents was recorded for each. The mean number of positive COVID-19 cases per 100 residents in this sample of 61 senior living facilities was 43.2, with a standard deviation of 8.7. If appropriate, use this information to test the hypotheses stated in part (a) at the a = .05 level of significance.

The median incomes of females in each state of the United States, including the District of Columbia and Puerto Rico, are given in table #2.2.10 ("Median income of," 2013). Create a frequency distribution, relative frequency distribution, and cumulative frequency distribution using 7 classes.

Table #2.2.10: Data of Median Income for Females

A researcher wanted to know the determinants of SAT scores in the United States of America. Using data from 4,137 survey respondents, the following equation was estimated:

????̂=    1,028.10 + 19.30ℎ???? −2.19ℎ????² −45.09?????? −169.81 ????? +62.31??????.?????

Standard Error:    (6.29) (3.83) (0.53) (4.29) (12.71) (18.15)

R²: 0.0858 n = 4,137
where Sat is the combined SAT score, hsize is the size of the student’s high school graduating class, in hundreds, female is a gender dummy variable, and black is a race dummy variable equal to one for blacks and zero otherwise.

(i) Is there strong evidence that hsize2 should be included in the model? From this equation, what is the optimal high school size?

(ii) Holding hsize fixed, what is the estimated difference in SAT score between nonblack females and nonblack males? How statistically significant is this estimated difference?

(iii) What is the estimated difference in SAT score between nonblack males and black males? Test the null hypothesis that there is no difference between their scores,

against the alternative that there is a difference.

(iv) What is the estimated difference in SAT score between black females and nonblack females? What would you need to do to test whether the difference is statistically
significant?

“In United States, there is strong tradition of use of police powers to protect the health of public in all civilized societies and there is also a strong tradition of individual liberty and civil rights. Politics determines the path the government will take in balancing these traditions. Public health is not based on scientific facts alone. It depends on politics to choose the values and ethics that determines how science will be applied to preserve people’s health while protecting their fundamental rights.” Please reflect on this statement by writing a critique essay on, is this a realistic view or pure exaggeration? Express your opinion taking into account current event(Public Health “preparedness for fighting COVID-19 Pandemic?) not less than 3 pages.