. You must use Excel (submit either a pdf, word or Excel file only).

. You must identify the 5 steps (you must address each in detail).

Problem: Use the given data to complete a t-test using Excel.

Question: Is there a difference in group means between the number of words spelled correctly for two groups of fourth graders?

Assume the following daily closings for the Dow Jones Industrial Average:

1. Calculate a four-day moving average for Days 4 through 12. Round your answers to two decimal places.

   Day	Moving average
   4
   5
   6
   7
   8
   9
   10
   11
   12

2. Assume that the index on Day 13 closes at 13,260. Would this signal a buy or sell decision?

   This would signal a (-Select-) buy sell Item 10 decision.

PC.62 Trek is a manufacturing company that produces high-end bicycles. Their prime road bike, the MadOne, can be fully customized through a program called Project One. Last year they rolled out 1,270 bikes which sold on average for $7,900 and used the following inputs as found in the table below:

What was last year's single-factor productivity for Trek in terms of rubber (not dollars)? (Display your answer to four decimal places.)


What was last year's single-factor productivity for Trek in terms of OCLV Carbon (input and output units, not dollars)? (Display your answer to four decimal places.)


What was last year's multi-factor productivity for Trek in terms of dollars? (In other words, how many dollars of revenue were generated for each dollar of input? Display your answer to two decimal places.)
   

Suppose in the coming year they expect their multi-factor productivity to increase by 10% over last year (what you just computed). What should be their multi-factor productivity in the coming year? (Display your answer to two decimal places.)
   

Compute and discuss elasticities for the following cases:

When consumer income increases by 4%, the demand for Ramen Noodles decreases by 6%. What is the income elasticity for Ramen Noodles? Explain what this income elasticity measure tells you.

When the price of bread increases by 7%, the demand for butter decreases by 9%. What is the cross-price elasticity? How are the two goods related – are they substitutes or complements? Explain why.

When the price of pork increases by 8%, the quantity of lamb purchased increases by 5%. What is the cross price elasticity? How are the two goods related - are they substitutes or complements? Explain why.

1. i) A 5 year semiannual coupon bond with a face value of $1000 trades at $868. The market-determined discount rate is 7%. What is the coupon rate? Answer in percent and round to two decimal places.

ii) If a bond always trades at a discount…

a) it is trading above par.

B) it is a coupon bond.

c) it is a zero coupon bond.

D) it is trading at par.

iii) A zero coupon bond with a face value of $1000 that matures in 8 years sells today for $627. What is the yield to maturity? (Use annual compounding.) Enter in percent to two decimal places.

APPLIED STATISTICS 2

USE R CODE! SHOW R CODE

Use data file RecordMath2526.txt, to produce a plot graph with Exam1 as x, Exam2 as y, use Gender as color, and Hw1 as pch.

RecordMath2526 information

Index Gender Hw1        Hw2     Hw3     Exam1   Hw4     Exam2   Hw5     Hw6     Hw7     Final
1       F      9        6       8       60      7       82      10      10      9       69
2       M     10        10      10      94      9       98      10      10      8       91
3       M      9        10      8       79      9       55      10      6       8       43
4       F     10        9       9       91      8       88      10      9       8       84
5       F      9        8       9       71      9       97      10      9       9       89
6       F      9        9       7       64      9       87      10      9       9       58
7       M      9        9       9       55      7       59      10      6       0       68
8       M      9        10      7       71      10      70      10      8       10      59
9       M      8        10      9       81      10      100     10      10      9       98
10      F      9        9       7       76      6       58      10      5       8       50
11      F     10        6       7       69      5       55      10      4       8       47
12      F      9        5       4       46      7       72      10      6       7       78
13      M      9        9       10      71      9       85      10      8       7       67
14      M      8        9       8       60      10      71      10      8       10      75
15      M      10       9       10      71      10      93      10      9       9       67
16      F      9        10      8       70      7       80      10      10      8       83
17      F      9        10      9       72      7       89      10      9       9       78
18      M     10        10      10      80      10      94      10      9       10      71
19      F     10        10      9       66      9       78      10      6       8       83
20      F      8        9       7       78      6       81      9       7       8       84      

APPLIED STATISTICS 2

USE R CODE! SHOW R CODE

Newton’s Law of Motion

Part 2 data: Tilted Track

(PLEASE SHOW ALL WORK)

1. Draw four FBD (free body diagrams) with Fnet vectors for the following four cases. (Neglect friction and drag.) (Define coordinate systems for each object, where each coordinate system is aligned with the object’s acceleration.)

a. Hanging mass while accelerating down (b). Cart on flat track while accelerating (from part 1 data)

c. Cart on inclined track while accelerating (d). Cart on declined track while accelerating (this is from part 2 data)

2. For case 1a above, write out Newton’s 2nd Law in the y-direction and solve for the tension: TH.

3. For cases 1b, 1c, and 1d, write out Newton’s 2nd Law in the x-direction and solve for the tension: TC.

4. Start an Excel data table and organize all your data (angles, mC, mH, and cart accelerations)

5. Nearby, start an Excel results table. Here, calculate the following quantities once per trial.

Reminder: If you use sine or cosine in MS Excel, it expects the angle to be entered in radians. You can input degrees by using “sin(radians(A1))” and “cos(radians(A1))”.    (Change “A1” to match your angle’s location.)

a. the net force acting on the cart, using Fnet=ma.

b. the net force acting on the hanging mass, using Fnet=ma.

c. the tension force, TH, acting on mH.

d. the tension force, TC, acting on mC. Do not use the tension value from part c!

e. the fraction TC/TH.     (What should this ratio be if your data was perfect?)

6. For your TC/TH values, calculate the average, standard deviation, and percent error between your average and the accepted value.

7. Make a single scatter plot showing the cart’s acceleration vs. the net force on the cart. Use three data series: 1) first four trials, 2) heavy cart, and 3) tilted track.

8. Add a linear trend line to each data set. For each trend line, use “Set Intercept” with a value of zero. Display the equation for each trend line.   (When the net force is zero, the acceleration had better be zero. Thus, the y-intercept should be 0 m/s2.)

Dr. Maureen Becker, the head administrator at Jefferson County Regional Hospital, must determine a schedule for nurses to make sure there are enough of them on duty throughout the day. During the day, the demand for nurses varies. Maureen has broken the day in to twelve 2-hour periods. The slowest time of the day encompasses the three periods from 12:00 A.M. to 6:00 A.M., which beginning at midnight; require a minimum of 30, 20, and 40 nurses, respectively. The demand for nurses steadily increases during the next four daytime periods. Beginning with the 6:00 A.M.- 8:00 A.M. period, a minimum of 50, 60, 80, and 80 nurses are required for these four periods, respectively. After 2:00 P.M. the demand for nurses decreases during the afternoon and evening hours. For the five 2-hour periods beginning at 2:00 P.M. and ending midnight, 70, 70, 60, 50, and 50 nurses are required, respectively. A nurse reports for duty at the beginning of one of the 2-hour periods and works 8 consecutive hours (which is required in the nurses’ contract). Dr. Becker wants to determine a nursing schedule that will meet the hospital’s minimum requirement throughout the day while using the minimum number of nurses.

A. Formulate a linear programming model for this problem

B. Solve this model by using the computer - I need to see the excel spreadsheet, formulas, and solver parameters.

Thank you!!!