Excel Assignment 2
Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are provided in previous assignment)
1. An Economist was interested in sex differences in the number of books a person reads (see file: Number of Books). Two random samples were taken, one of men and the other, and the number of books read during the last month was recorded. Is there a difference with respect to the number of books read by females and males?

A disk of radius 14 cm and has a mass of 10 kg is attached to a hub which is a
disk of mass 8 kg and radius 5cm. The disks are mounted on a frictionless axel
that runs through the center. A rope passes over the hub and supports a 10 kg
mass on one side and a 5 kg mass on the other. If the rope does not slip on the
hub,
a.) What is the tension in the segment of the rope that has the 10 kg mass
b.) What is the torque on the rope above the 5 kg mass?
c.) What is the angular acceleration?
d.) What is the velocity of the 10 kg mass after it has fallen 30 cm?

A retail chain has eight stores in a region supplied from four supply sources. Trucks have a capacity of 40,000 units and cost $1,000 per load plus $100 per delivery. Thus, a truck making two deliveries charges $1,200. The cost of holding one unit in inventory at retail for a year is $0.20.

• The vice president of the supply chain is considering whether to use direct shipping from suppliers to retail stores or setting up milk runs from suppliers to retail stores. • What network do you recommend if annual sales for each product at each retail store are 960,000 units?

• What network do you recommend if sales for each product at each retail store are 120,000 units?

please provide me a step by step detailed solution in excel

Payroll Register

The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9, 20Y8:

Employees Mantle and Williams are office staff, and all of the other employees are sales personnel. All sales personnel are paid 1½ times the regular rate for all hours in excess of 40 hours per week. The social security tax rate is 6%, and Medicare tax is 1.5% of each employee's annual earnings. The next payroll check to be used is No. 901.

Required:

1. Prepare a payroll register for Throwback Industries Inc. for the week ended December 9, 20Y8. Assume the normal working hours in a week are 40 hours. Enter amounts as positive numbers. Round your intermediate calculations and final answers to the nearest whole cent (two decimal places).

2. Journalize the entry to record the payroll for the week. If required, round your answers to two decimal places. If an amount box does not require an entry, leave it blank.

Tom’s Top End Motors and Fast Eddie’s Quality Cars are two local used car dealers. Tom and Eddie are comparing their sales. The mean monthly sales are similar, however, Tom Monroe (owner of Tom’s Top End Motors) thinks his sales are no more consistent than Fast Eddie’s. Below is a listing of the number of cars sold for the last eight months for Tom’s Top End Motors and for the last seven months for Fast Eddie’s Quality Cars.

Conduct a hypothesis test (using α = 0.05) to see if you agree with Tom’s view that his sales are no more consistent.

List all the steps of the hypothesis test and write a note to Tom telling him whether you agree with him or not and back up your conclusion.

Match the following to their descriptions: A research study that examines the mean number of pounds loss in a weight loss clinic. Answer 1 A research study that compares the mean number of pounds loss between two different weight loss clinics. Answer 2 A research study that weighs individuals at the beginning of the weight loss program and measures the same individual at the end of the program and calculates the difference in weight for each individual. Answer 3 A research study that examines what percentage of individuals actually lost weight during the weight loss program. Answer 4 A research study that examines there is a difference in the percentage of individuals that have lost weight in clinic 1 versus in clinic 2. Answer 5

Olsen Outfitters Inc. believes that its optimal capital structure consists of 50% common equity and 50% debt, and its tax rate is 40%. Olsen must raise additional capital to fund its upcoming expansion. The firm will have $1 million of retained earnings with a cost of r_s = 12%. New common stock in an amount up to $8 million would have a cost of r_e = 14%. Furthermore, Olsen can raise up to $3 million of debt at an interest rate of r_d = 11% and an additional $5 million of debt at r_d = 14%. The CFO estimates that a proposed expansion would require an investment of $3.5 million. What is the WACC for the last dollar raised to complete the expansion? Round your answer to two decimal places.

Abdullah is a batsman who has played 10 matches in a local cricket club. Take user input in a 2D array to store his score in first row and second row for balls he has faced in each match.

Calculate and display the strike rate (SR) of Mr. Abdullah in all 10 matches he has played.

SR=score/number of balls faced×100

Count and display the number of 50s and 100s he has score.

An architect wants to determine the relationship between the heights (in feet) of a building and the number of stories in the building. The data for a sample of 10 buildings are shown.

Stories (x) 64 54 40 31 45 38 42 41 37 40

Height (y) 841 725 635 616 615 582 535 520 511 485

Is there a significant linear correlation between the two variables ? Use α = .05

What would be the best predicted Height of a building with 44 Stories ? Round your answer to one decimal place (i.e. one digit to the right of the decimal point)