1. A survey conducted by a research team was to investigate how the education level, tenure in current employment, and age are related to annual income. A sample of 20 employees is selected and the data are given below.

Please show the process of Excel analysis, thank you

a. Check if the F test leads to conclude that an overall regression relationship exists. If yes, use the t test to determine the significance of each independent variable. What is the conclusion for each test at the 0.05 level of significance?

b. Remove all independent variables that are not significant at the 0.05 level of significance from the estimated regression equation. What is your estimated regression equation in this case? Provide an interpretation of the coefficients in regards to the independent variables.

Arndt, Inc., reported the following for 2018 and 2019 ($ in millions):

1. Expenses each year include $20 million from a two-year casualty insurance policy purchased in 2018 for $40 million. The cost is tax deductible in 2018.
2. Expenses include $2 million insurance premiums each year for life insurance on key executives.
3. Arndt sells one-year subscriptions to a weekly journal. Subscription sales collected and taxable in 2018 and 2019 were $26 million and $31 million, respectively. Subscriptions included in 2018 and 2019 financial reporting revenues were $18 million ($7 million collected in 2017 but not recognized as revenue until 2018) and $26 million, respectively. Hint: View this as two temporary differences—one reversing in 2018; one originating in 2018.
4. 2018 expenses included a $15 million unrealized loss from reducing investments (classified as trading securities) to fair value. The investments were sold in 2019.
5. During 2017, accounting income included an estimated loss of $4 million from having accrued a loss contingency. The loss was paid in 2018 at which time it is tax deductible.
6. At January 1, 2018, Arndt had a deferred tax asset of $4 million and no deferred tax liability.

4. Prepare a schedule that reconciles the difference between pretax accounting income and taxable income. Using the schedule, prepare the necessary journal entry to record income taxes for 2019.

1. Two golf balls are selected with replacement from a bowl containing 7 red and 3 blue balls
   1. What is the probability that both balls are red?
   2. What is the probability that both balls are blue?
   3. What is the probability that the first ball is red and the second ball is blue?
   4. What is the probability that the first ball is blue and the second ball is red?
   5. What is the probability that the two balls selected are the same color?
2. Adam goes to the grocery store. Suppose probability he buys milk is 40%, and the probability he buys steak is 70%, and the probability of both is 30%. What is the probability that he buys either milk or steak?
3. A car dealer has had issues with new cars that are being delivered with flawed paint and tires that are one too small. The two assembly shops are not related to one another. If the probability of flawed paint is 5% and the probability of the wrong size tire is 8%, then what is the probability that the next car delivered will have flawed paint and too small tires?

1.

Write a class Rectangles which manages an array of Rectangle objects.

The constructor of the Rectangles takes an array of Rectangle objects. You can assume the array is filled

Provide these methods

• An averageArea method that returns the average area of the Rectangle objects in the array. Only divide one time
• A method swapMaxAndMin which swaps the Rectangle with the largest area with the one with the smallest area in the array. Only use one loop
• A method toString which returns the string representation of the underlying array. (You can use Arrays.toString)

Provide javadoc

Tester File:

RectanglesTester.java

import java.awt.Rectangle;

public class RectanglesTester
{


        public static void main(String[] args)
        {
                Rectangle[] recs = {
                                new Rectangle(30, 50,  5, 20),
                                new Rectangle(20, 40, 50, 40),
                                new Rectangle(10, 10, 20, 10),
                                new Rectangle(50, 10, 2, 8)
                };

                Rectangles processor = new Rectangles(recs);


                System.out.printf("Aveage: %.2f\n", processor.averageArea());
                System.out.println("Expected: 579.00");

                processor.swapMaxAndMin();
                System.out.println(processor.toString());
                System.out.println("Expected: [java.awt.Rectangle[x=30,y=50,width=5,height=20], java.awt.Rectangle[x=50,y=10,width=2,height=8], java.awt.Rectangle[x=10,y=10,width=20,height=10], java.awt.Rectangle[x=20,y=40,width=50,height=40]]");

                Rectangle[] recs2 = {
                                new Rectangle(30, 50,  5, 20),
                                new Rectangle(20, 40, 50, 40),
                                new Rectangle(10, 10, 20, 10),
                };

                Rectangles processor2 = new Rectangles(recs2);


                System.out.printf("Aveage: %.2f\n", processor2.averageArea());
                System.out.println("Expected: 766.67");

                processor2.swapMaxAndMin();
                System.out.println(processor2.toString());
                System.out.println("Expected: [java.awt.Rectangle[x=20,y=40,width=50,height=40], java.awt.Rectangle[x=30,y=50,width=5,height=20], java.awt.Rectangle[x=10,y=10,width=20,height=10]]");
        }
}

2. Zulkifli, computer centre manager, reports that this computer system experienced three-component failure during the past 100 days. What is the probability of no failure?

Select one:

a. 0.004

b. 0.97

c. 0.996

d. 0.03

4. Suppose that women obtain 54% of all bachelor’s degrees in a particular country and that 20% of all bachelor’s degrees in business. Also, 8% of all bachelor’s degrees go to women majoring in business. The events “the bachelor’s degree holder is a woman” and the bachelor’s degree is in business” are _____________.

Select one:

A. statistically correlated

B. statistically independent

C. statistically not independent

D. statistically dependent

5. The variance for the data values “ 87, 85, 80, 78, 86, 90” is :

Select one:

A. 12

B. 4.1

C. 85

D. 17.1

6.

A company is hiring candidates for 4 key positions in the management of its new office. 5 candidates are from Malaysia and 3 are from United States. Assuming that every combination of Malaysian and American is equally likely to be selected, what is the probability that at least 1 American will be selected?

Select one:

A. 5/14

B. 1/14

C. 4/14

D. 13/14

7.

A researcher wants to investigate if there is a difference in the rates of hotel room in two cities. A sample of 50 were selected from each city, the average hotel room in the first city is RM88.42 and in the second city is RM80.61 and the standard deviation are RM5.62 and RM4. The null hypothesis for the difference between the means is

Select one:

A. µ1 - µ2 ≤ 0

B. µ1 - µ2 ≥ 0

C. µ1 - µ2 ≠ 0

D. µ1 - µ2 = 0

8.

The intercept of the regression equation for the following data:

Select one:

A. 87.3922

B. 85.3421

C. 89.3421

D. 83.3421

9.

The number of credits in business courses ten job applicants had is shown here. “ 2, 3, 5, 6, 8, 10, 12, 15, 18, 20”

What value corresponds to the 60th percentile?

Select one:

A. 12

B. 8

C. 11

D. 10

10.

Zulkifli, computer centre manager, reports that this computer system experienced three-component failure during the past 100 days. What is the probability of at least two failures in a 3-day period?

Select one:

A. 0.004

B. 0.91

C. 0.03

D. 0.08

1. Catherine’s the new CEO of an exercise equipment company and she wants to know if her time as CEO has affected the return rates of treadmills. Before she became CEO, 8% of treadmills were returned. What’s the null and alternative hypotheses of any tests she runs?

2. Imagine you were testing if a new battery lasts longer than the industry standard. You perform the appropriate hypothesis test with an unbiased sample and found statistical signifance at 99.9% confidence. It would be a mistake to claim that you “proved” this new batter lasts longer. Why?

7. Suppose the number of photons emitted by an atom during a one-minute time window can be modeled as a Poisson random variable with parameter ? = 2. Now, suppose you watch the atom for two minutes, and the number of emitted photons in each minute is an independent Poisson process. Calculate the probability that you see exactly one photon during the two minutes. (Hint: this is the probability that you see no photons in the first minute and one photon in the second minute, plus the probability that you see one photon in the first minute and no photons in the

second minute.) Similarly calculate the probability that you see exactly two photons during the two minutes.

Compare these probabilities to the probabilities that a Poisson random variable with parameter ? = 4 takes the value one, or two. Are they the same?

8. Sketch the PDF and CDF of a continuous random variable that is uniform on [0,2].

9. A line segment of length 1 is cut once at random. What is the probability that the longer piece is more than twice the length of the shorter piece?

10. An atom of Uranium-238 is unstable and will eventually decay (i.e., emit a particle and turn into a different element). Given an atom of Uranium-238, the time elapsed until it decays, in years, is modeled as an Exponential random variable with parameter ? = 0.000000000155. How many years must pass for there to be a 50% chance that the Uranium atom decays?

Suppose that the following are the quarterly sales data for the past 7 years.

1.Construct a time series plot and develop linear trend equation using the original data (with seasonal components).

2.Calculate 4-quarter moving average values for this time series (column E).

3.Calculate centered moving average values and seasonal indexes (column F and G).

4.Calculate seasonal indexes (column J) for the four quarters.

5.Copy seasonal indexes (column J) to column O, and calculate deseasonalized number sold (column P).

6.Construct a time series plot and develop linear trend equation using the deseasonalized data (without seasonal components).

1. A retail store runs an advertising campaign on a radio station. They decide to measure the effectiveness of the campaign by measuring the increase in customers compared to previous days. They choose 35 days at random, and find the average number of customers to have increased by 83.3 customers per day. Historically, the number of customers per day has a standard deviation of 17.5 customers. What is the 95% confidence interval for the population mean increase in customers?

Select one:

a. 79.51 to 87.09

b. 79.54 to 87.06

c. 77.50 to 89.10

d. 55.70 to 110.90

e. 78.42 to 88.18

2. A movie theater in a tourist destination notices that their attendance improves when it is rainy outside. For the past year, the standard deviation of movie attendance has been 6.1 people. The theater looks at the attendance of 42 movies while it was raining last month, and the average attendance was 91.2 people per showing. What is the 80% confidence interval?

Select one:

a. 89.65 to 92.75

b. 73.19 to 109.21

c. 90.00 to 92.40

d. 89.36 to 93.04

e. 91.01 to 91.39