In the Accumulation column calculate the balance of the investment each month assuming it grew at an interest rate of 12% per year (Cell- G6) over 40 years for both sheets.

/in /by

Mortgage Analysis

Part I

  1. (10 points) Type your name in the title and fill in the terms for each scenario in sheet 1 and 2. Cells- A6:D6
  2.  (10 points)Calculate the monthly payment using the equation for both terms. Cell- E6
  3.  (10 points)Use the built in PMT function in Excel to verify the payment is correct. Cell- F6
  4.  (40 points)Create Amortization tables for both sheets. Cells- A11:E11 (and down for the length of the mortgage)

 

Part II                    

  1.  (10 points)In the Investment column calculate the amount of money that will be invested each month for both sheets. Remember once the house is paid off the full $2000 will be invested. Cells- G11:down for 40 years
  2. 6.  (40 points)In the Accumulation column calculate the balance of the investment each month assuming it grew at an interest rate of 12% per year (Cell- G6) over 40 years for both sheets. Cells- H11:down for 40 years
  3. (20 points)Use the built in FV function of Excel to verify the total amount accumulated in both sheets. Remember at some point the investment amount changes; therefore, you will need to use the FV function more than once. Final Answer: Cell- H6

 

 

Part III

  1. (10 points) Calculate the property taxes for the first ten years assuming they are $2000 for year 1 and rise by 3% each year. Cells- L6:L15
  2. (10 points) Calculate the total interest paid each year for the first ten years of the loan. Remember the Amortization Schedule is in months and we are constructing this table in years. Cells- M6:M15
  3. (10 points) The Tax Deduction is the sum of the interest paid for the year and the property tax. Calculate the tax deduction for the first ten years. Cells- N6:N15
  4. (10 points) We will call the last column Tax Benefit. To simplify calculations let’s assume the couple are in the 25% tax bracket, so the tax deduction will lower their taxes due by approximately 25% of the deduction. However, a person who doesn’t own a house doesn’t pay the property taxes. So, this column will be the difference between the tax savings (25% of the deduction) and the property tax. Cells- O6:O15

 

Part IV

  1. (20 points) Write a reflection. Share some of your findings. What did you find interesting? Anything shocking? Are you left with any “what if” questions?

Note: If each calculation is built upon functions calling on cells you should be able to adjust any of the terms to see what happens if you change anything. Cell- K18

Two separate samples receive two different treatments. The first treatment group (N = 9) has a mean of 50 with SS = 710. The second treatment group (N = 6) has a mean of 60 with SS = 460. Is the second treatment group significantly larger than the first? What is the effect size?

/in /by

PSYC 2317: Statistical Methods for Psychology

Tarleton State University

Unit 7 Homework

For each of the hypothesis testing problems below, you need to justify your answer by explicitly defining your null hypothesis H0 and alternative hypothesis H1 and reporting the p-value for the resulting test statistic.

1. Two separate samples receive two different treatments. The first treatment group (N = 9) has a mean of 50 with SS = 710. The second treatment group (N = 6) has a mean of 60 with SS = 460. Is the second treatment group significantly larger than the first? What is the effect size?

2. A researcher surveys a group of college students to determine the negative life events that they experienced in the past 5 years and their current feeling of well-being. For N = 18 participants with 2 or fewer negative experiences, the average well-being score was X = 42 with SS = 398. For the N = 16 participants with 5 to 10 negative experiences the average score is X = 48.6 with SS = 370. Is there a significant difference between the two populations represented by these two samples? What is the effect size?

3. In 1974, Loftus and Palmer conducted a classic study demonstrating how the language used to ask a question can influence eyewitness memory. In the study, college students watched a film of an automobile accident and then they were asked questions about what they saw. One group was asked “About how fast were the cars going when they smashed into each other?” Another group was asked the same question except the verb was changed to “hit” instead of “smashed into”. The “smashed into” group reported significantly higher estimates of speed than the “hit” group. Suppose a researcher repeats the study with a sample of today’s college students and obtains the following results:

  • Smashed into Hit
    n = 15 n = 15
    M = 40.8 M = 34.0
    SS = 510 SS = 414

Do the results indicate a significantly higher estimated speed for the “smashed into” group? What is the effect size?

Think about the recent vaccinations developed for Covid in record time. Do you recall reading about the items above, and are they important?

/in /by

WK 9 – MGMT 650 Discussion

Balancing the Risks of Errors in Hypothesis Testing
The U.S. FDA is responsible for approving new drugs. Many consumer groups feel that the approval process is too easy and, therefore, too many medications that are later found to be unsafe are approved. On the other hand, several industry lobbyists have pushed for a more lenient approval process, so pharmaceutical companies can get new drugs approved more easily and quickly. This is from an article in the Wall Street Journal. Consider a null hypothesis that a new, unapproved drug is unsafe and an alternative hypothesis that a new, unapproved drug is safe.

  • a) Explain the risks of committing a Type 1 or Type 2 error.
  • b) Which type of error is the consumer group trying to avoid?
  • c) Which type of error is the industry lobbyists trying to avoid?
  • d) How would it be possible to lower the chances of both Type 1 and 2 errors?

Think about the recent vaccinations developed for Covid in record time. Do you recall reading about the items above, and are they important?

In 6-sentences or more, explain how the confidence interval procedure can be applied at the workplace for the position.

/in /by

WK 7 MGMT 650 – Employing The Normal Distribution

Confidence Intervals at the Workplace

Web site:

https://www.mathsisfun.com/data/confidence-interval.html
https://mathbitsnotebook.com/Algebra2/Statistics/STmarginError.html

Case scenario.

At the workplace, you are the research team leader.
The Boss wants your team to collect data to establish a confidence interval for a situation at work.
In 6-sentences or more, explain how the confidence interval procedure can be applied at the workplace for the position.

Find data that appears to have a linear or exponential trend. Find data that someone hasn’t already used. Create a new thread in this forum.

/in /by

Growth Models Discussion, Linear or Exponential Analysis

1. Search the Internet to find a graph or table of values that shows how something is changing over time. The data should be real measured data (not some made-up values for a math problem example or something), and should show something that is changing linear or exponentially.

  • The graph or table should show data for at least 4 time periods (years, months, etc.)
  • Find data that appears to have a linear or exponential trend.
  • Find data that someone hasn’t already used.
  • Create a new thread in this forum.
  • Paste in the web link (+1 pt for including)
  • State whether the data appears to be changing linearly or exponentially, and give a reason (1 pt)
  • Find an explicit equation to model the data, clearly defining your variables and showing your work (5 pts)
  • Use your model to make a prediction about the future (2 pts)

Calculate the total interest paid each year for the first ten years of the loan. Remember the Amortization Schedule is in months and we are constructing this table in years. Cells- M6:M15

/in /by

Mortgage Analysis

Part I

  1. (10 points) Type your name in the title and fill in the terms for each scenario in sheet 1 and 2. Cells- A6:D6
  2.  (10 points)Calculate the monthly payment using the equation for both terms. Cell- E6
  3.  (10 points)Use the built in PMT function in Excel to verify the payment is correct. Cell- F6
  4.  (40 points)Create Amortization tables for both sheets. Cells- A11:E11 (and down for the length of the mortgage)

 

Part II                    

  1.  (10 points)In the Investment column calculate the amount of money that will be invested each month for both sheets. Remember once the house is paid off the full $2000 will be invested. Cells- G11:down for 40 years
  2. 6.  (40 points)In the Accumulation column calculate the balance of the investment each month assuming it grew at an interest rate of 12% per year (Cell- G6) over 40 years for both sheets. Cells- H11:down for 40 years
  3. (20 points)Use the built in FV function of Excel to verify the total amount accumulated in both sheets. Remember at some point the investment amount changes; therefore, you will need to use the FV function more than once. Final Answer: Cell- H6

 

 

Part III

  1. (10 points) Calculate the property taxes for the first ten years assuming they are $2000 for year 1 and rise by 3% each year. Cells- L6:L15
  2. (10 points) Calculate the total interest paid each year for the first ten years of the loan. Remember the Amortization Schedule is in months and we are constructing this table in years. Cells- M6:M15
  3. (10 points) The Tax Deduction is the sum of the interest paid for the year and the property tax. Calculate the tax deduction for the first ten years. Cells- N6:N15
  4. (10 points) We will call the last column Tax Benefit. To simplify calculations let’s assume the couple are in the 25% tax bracket, so the tax deduction will lower their taxes due by approximately 25% of the deduction. However, a person who doesn’t own a house doesn’t pay the property taxes. So, this column will be the difference between the tax savings (25% of the deduction) and the property tax. Cells- O6:O15

 

Part IV

  1. (20 points) Write a reflection. Share some of your findings. What did you find interesting? Anything shocking? Are you left with any “what if” questions?

Note: If each calculation is built upon functions calling on cells you should be able to adjust any of the terms to see what happens if you change anything. Cell- K18

For what positive values of b do. y°(t) + by'(t) + 4y(t) = 0 have solutions that are overdamped oscillators? Explain.

/in /by

DE questions

Instructions: Write up neat, organized solutions to ALL problems ON YOUR OWN. Be sure to include acknowledgment of anyone who you worked with or received help from.

Problem 1 For what positive values of b do. y°(t) + by'(t) + 4y(t) = 0 have solutions that are overdamped oscillators? Explain.

Problem 2 An inductor (L =1 II) and resistor (R = 0.1 Ohms) are joined in series with a voltage source with E(t) = 10 — 2t volts. If there is no current at time t = 0, find an expression for the current in the circuit at time t. Hint: Go back to the handout on circuits. Which variable is used to denote the current? What is the relevant differential equation for the cumnt?

Problem 3 Find the inverse Laplace Transforms, by manipulating the functions to match a form in our table.
(a) Y(,) = — rft (b) Y(s) (,t1) ‘2F4 (c) Y(s) =

In right triangle ABC, angle C = 90 degrees. Angle A = 40 degrees and the length of the leg opposite angle B is 18 feet. Find the length of the hypotenuse to the nearest tenth.

/in /by

Mathematics Question

                                                                          (Show all your Work)

1. Find the Domain and Range for .

Dom:                                                                       Range:

2. Simplify

3. The total amount paid for a car is . Set up an equation that includes the total amount paid for the car, the original price (without tax) of the car, , and a   Then solve the equation to find the original price of the car before tax .

4. (a) What is the exact value of ? [Keep answer in radical form]

(b) If , find two values for angle .

5. A waterslide is long . The top of the slide is  above the ground. Find the angle of elevation of the waterslide.

6. Solve for in terms of  if

7. In triangle ABC, the lengths of the sides in feet are . Find angle C.

8. Find the equation of the line through the points and .

9. For the lines with the following equations and , is the point on both lines? Explain your answer both graphically and algebraically.

10. In right triangle ABC, angle C = 90 degrees. Angle A = 40 degrees and the length of the leg opposite angle B is 18 feet. Find the length of the hypotenuse to the nearest tenth.

If a hansom cab ride costs $220 if you drive for 5 miles around NYC, and $169 if you drive 2 miles. Find the equation that defines this relationship.

/in /by

MIDTERM Math 109

Find the domain and range of Y= 5 + – 2).

  1. Domain is a) (2, .0) b) [2, 00) c) (2, 00] d) none of these.
  2. Range is a) (5, co) b) (-.0, 5] c) 5) d) none of these.

Find the domain and range of Y = -2 – I x – 5 I

  1. Domain is a) All Real’s except -2 b) (-00, 00) c) (-.0, 5) d) none of these.
  2. Range is a) All Real’s except 5 b) (-Do, -2] c) (-00, 5] d) none of these.

5. Given that the points (4,-3) and (2, 10) lie on the same line, find its slope.

  • a) 13/2
  • b)-13/2
  • c) -12
  • d) none of these.

6. Given the linear equation x – 3y +5 = 0, find its y intercept.

  • a) — 5
  • b) -5/3
  • c) 5/3
  • d) none of these

Find the the domain and range of Y= -(x + 2)2 -4

  • Domain is a) (-.0, co) b) All Real’s except 4 c) All Real’s except ±2 d) one of these.
  • Range is a) All Real’s except ±4 b) (-00, .0) c) (-00, -4] d) none of these.

9. Find the Cos 8 if 8 is the angle formed by connecting the point (3,-3) to the origin and then forming a triangle in standarc form.

  • a) -3-42
  • b) -1k 2
  • c) 1N 2
  • d) None of these.

10. Find the Tan 0 if Cot 0 = -5/2

  • a) -5/2
  • b) 2 /5
  • c) -2/5
  • d) None of these.

11. Find 0 to the nearest degree if 0 is the angle formed by connecting the point (3,-3) to the origin and then forming a triangle in standard form.

  • a) 30°
  • b) 135°
  • c) 315°
  • d) None of these.

12. If Cot O = -5/2, find 0 to the nearest degree

  • a) 159°
  • b) 158°, 338°
  • c) 159°, 339°
  • d) None of these.

13. Cos 855°

  • a) -.6333
  • b) -1/2
  • c) -1N2
  • d) None of these.

14. A ladder leans against the side of a building and makes an angle of 12° with the ground. If the height the ladder reaches on the building is 29 feet, find the distance (to the nearest foot) the base of the ladder is from the base of the building.

  • a) 256 feet
  • b) 310 feet
  • c) 136 feet
  • d) None of these.

15. Using the data from question 14, what is the angle of depression from the point on the building where the ladder reached to the base of the ladder?

  • a) 0°
  • b) 12°
  • c) 78°
  • d) None of these.

16. In triangle ABC, a = 23 ft, b =14ft, and c = 18 ft. Find angle B to the nearest degree

  • a) 30
  • b) 34
  • c) 37
  • d) None of these.

17. Find the acute angle 8 to the nearest degree if Cos 8 = 1/2.

  • a) 30
  • b) 45
  • c) 60
  • d) None of these.

18. Simplify the following 7(x -2y) – (x + 2y)

  • a) 4x -14y
  • b)-6x -14y
  • c) 6x — 16y
  • d) none of these.

19. Evaluate -16 + 3(53)

  • a) 391
  • b) 359
  • c) 59
  • d) none of these.

20. If a hansom cab ride costs $220 if you drive for 5 miles around NYC, and $169 if you drive 2 miles. Find the equation that defines this relationship.

  • a) Y = 17x -135
  • b) Y = 17x +135
  • c) Y = 7x +135
  • d) none of these.

21. Solve for x. 3H = -1

  • a) -1/15H + 1/5
  • b) 1/15H – 1/5
  • c) -1/15H – 1/5
  • d) none of these.

22. Solve for x. 4 – x > 2(-2x – 6)

  • a) (-8/3, co)
  • b) (-00, 16/3]
  • c) (-16/3, co)
  • d) none of these.

23. A car dealer offers a new car at a price of $57,500. The selling price represents a profit of 141/2%. How much did the car cost the dealer? Round to the dearest dollar.

  • a) $50,000
  • b) $50,218
  • c) $26,218
  • d) none of these.

24. A cliff 3119 feet high casts a shadow 44 feet long at the same time that a tree casts a shadow 37 feet long. What is the height of the tree to the nearest foot?

  • a) 2,222
  • b) 2,623
  • c) 26,218
  • d) none of these

25. Evaluate to the nearest hundredth 320,000(1 +..0875/12)3°x12

  • a) 3,075,591.03
  • b) 4,375,591.03
  • c) 4,375,591.33
  • d) None of these

Come up with at least 15 data entries. Create a video explaining your data and how to calculate the point estimate for the population mean. Include in your video how to obtain a 95% confidence interval for the mean.

/in /by

W6 Discussion Question 1: Can you teach a confidence interval?

Purpose : The purpose of this week’s discussion is to demonstrate mastery of computing a point estimate by teaching to other students.

Post: Sometimes, teaching other students is the best way to show that you understand something. If you can teach your classmates to learn from your instruction, then you are truly mastering the topic.

This week, research something important in your life right now. (Examples include wedding costs, book costs, fuel tank capacities of vehicles, cholesterol levels, 1-mile running times, etc). Come up with at least 15 data entries. Create a video explaining your data and how to calculate the point estimate for the population mean. Also, include in your video how to obtain a 95% confidence interval for the mean.