Ingrid types
Ingrid types 3 pages in the same amount of time that Tanya types 4.5 pages.If Ingrid and Tanya start typing...,"Ingrid types 3 pages in the same amount of time that Tanya types 4.5 pages.If Ingrid and Tanya start typing at the same time, how many pages will Tanya have typed when Ingrid has typed 11 pages.
Use excel help you optimize complex projects
Week Two - Assignment 3 of 4
And if you'd like to see how Excel can really help you optimize complex projects, try out this example by using the imbedded SOLVER fucntion (see Data tab. Install under File, Options, Add-ins.)
Questions: Given that the current construction project is planned to be completed in 30 days.
What is the best way to meet the expedited request of 26 days?
What is the cost to expedite the project?
If you want even more insight into managing your project, consider using specialized software tools such as Microsoft PROJECT -- see your Single-Sign On page for Lynda.com resources and then search for ""Microsoft Project 2016 Essential Training"".
Earthmover Project Plan.xlsx - Excel Document (13 KB)
HINTS -- to install SOLVER:
Excel: Open a document, under File, select Options, then select Add-ins, then by ”Manage… Excel Add-ins” click GO, check the box for “Solver Add-In”, and finally click OK.
Google Sheets: Open a document, in the top-menu select ""Add-ins"", select ""Get Add-ins"", search for Solver and click FREE.
Statistics
Why is the frequent use of chi-square in social work research both good and bad?
How is the test particularly well suited to social work research?
Introduction to Proof and Problem Solving
,"2.9: 6
2.10: 8
3.2: 6
3.3: 4
3.3: 10
3.4: 4
3.4: 8
3.5: 10
3.5: 12
For all the exercises 3.2 (6) through 3.5 (12) you have to justify your answer.
Use LaTeX for all parts. Each of the 9 problems on a separate page (use command \newpage in LaTeX). When uploading, indicate which problem is on which page.
Math 55
Under what conditions, if any, can the sum of two squares be factored? Explain
Project
1. The hypothesis is to predict cancer mortality rates in the United States counties.
Questions asked when I sent the proposal
Can you be a little more specific about the variables? What will be your outcome/s? Is this a variable in the dataset or is it a variable that you need to calculate from other variables in the dataset?. When you talk about counties, do you mean you want to compare if the mortality rate is different between counties? Do you have several observations per county?. If you only have one per county you can’t do statistical inference using counties. I see a lot of continuous variables in the dataset, it seems to me that it would be easy to run regression models where you can have a mortality rate as the outcome and then one or more of the other variables as predictors
Conduct an analysis and hypothesis test
Conduct an analysis and hypothesis test of your choice on the data you collected. Write a 250-500 word research summary of the findings generated in the assignments for Topics 2 through 5. The research summary should address the following.
1. Explain what type of analysis and hypothesis test was conducted on the data collected.
2. Summarize the survey results based on the results of the data you analyzed.
3. Include the Excel analysis as part of the document.
Please provide all references that are used. APA format 7th edition.
How to calculate this scenario?
If I have two Products (Product A and Product B) and I want to ship these products to customers as follows:
Product A (# of units: 4000)
Product B (# of units: 4000)
The products must be shipped through using Pallets.
Each Pallet can hold 1000 units of Products A or 2000 units of Product B.
Transportation cost for both Products (A and B) is the same. $1 dollar per pallet.
Question: How many pallets I need to ship theses products? What is the final price the customer must for shipment?
Matrix Alergra Exam
I have an exam that will have a limit time 3 hours, You may need to login my account
Finite Mathematics
1. The unpaid balance at the start of a 28-day billing cycle was $997.81. A $6,000 purchase was made on the first day of the billing cycle and a $100 payment was credited to the account on day 21. How much interest will be charged at the end of the billing cycle? Assume that the annual interest rate on a credit card is 26.16% and interest is calculated by the average daily balance method.
At the end of the billing cycle, $________ will be charged in interest.
(Round to the nearest cent as needed.)
2. The unpaid balance at the start of a 30-day billing cycle was $615.37. No purchases were made during the billing cycle and a payment of $615.37 was credited to the account on day20. Find the unpaid balance at the end of the billing cycle. Assume that the annual interest rate on a credit card is 20.36% and interest is calculated by the average daily balance method.
The unpaid balance at the end of the billing cycle is $_______
(Round to the nearest cent as needed.)
3. The unpaid balance at the start of a 30-day billing cycle was $791.99. A purchase of $59.81 was made on day 15. No payment was made during the billing cycle and a late fee of $31 was charged to the account on day 23. Find the unpaid balance at the end of the billing cycle. Assume that the annual interest rate on a credit card is 20.39% and interest is calculated by the average daily balance method.
The unpaid balance at the end of the billing cycle is $_______
(Round to the nearest cent as needed.)
4. A payday loan is a short-term loan that is repaid on the next payday, often by giving the lender electronic access to a personal checking account. Some states have statutes that regulate the fees that may be charged for payday loans. Suppose that, in a certain state, finance charges on a payday loan may not exceed 17.7% of the amount advanced. Find the annual interest rate if $300 is borrowed for 11 days at the maximum allowable charge.
The annual interest rate is______%.
(Round to the nearest percent as needed.)
5. If $700 is invested at 8% compounded
(A) annually, (B) quarterly, (C) monthly,
What is the amount after 4 years? How much interest is earned?
What is the amount
What is the amount
6. How long will it take money to triple if it is invested at 5% compounded monthly? 6.4% compounded continuously?
It will take about ____years at 5% compounded monthly.
(Round to two decimal places as needed.)
It will take about ____years at 6.4% compounded continuously.
(Round to two decimal places as needed.)
7. Use graphical approximation techniques or an equation solver to approximate the desired interest rate. A person makes annual payments of $1000 into an ordinary annuity. At the end of 5 years, the amount in the annuity is $5720.98. What annual nominal compounding rate has this annuity earned?
Type the interest rate:______%
(Round to 2 decimal places.)
8. Use graphical approximation techniques or an equation solver to approximate the desired interest rate. An employee opens a credit union account and deposits $110 at the end of each month. After one year, the account contains $1325.09. What annual nominal rate compounded monthly has the account earned?
The annual nominal rate is ______%.
(Round the final answer to two decimal places as needed. Round all intermediate values to six decimal places as needed.)
9. A woman borrows $4000 at 12% compounded monthly, which is to be amortized over 3 years in equal monthly payments. For tax purposes, she needs to know the amount of interest paid during each year of the loan. Find the interest paid during the first year, the second year, and the third year of the loan. [Hint: Find the unpaid balance after 12 payments and after 24 payments.]
The interest paid during the first year is $________
(Round to the nearest cent as needed.)
10. A family has a $111,408, 30-year mortgage at 6.3% compounded monthly. Find the monthly payment. Also find the unpaid balance after the following periods of time.
(A) 10 years (B) 20 years (C) 25 years
The monthly payment is $_______
(A)
(B)
(C)
11. A family has a $92,529, 25-year mortgage at 6% compounded monthly.
Find the monthly payment and the total interest paid.
Suppose the family decides to add an extra $100 to its mortgage payment each month starting with the very first payment. How long will it take the family to pay off the mortgage? How much interest will the family save?
12. An ordinary annuity pays 8.04% compounded monthly.
A person deposits $100 monthly for 30 years and then makes equal monthly withdrawals for the next 15 years, reducing the balance to zero. What are the monthly withdrawals? How much interest is earned during the entire 45-year process?
If the person wants to make withdrawals of 1,500 per month for the last 15 years, how much must be deposited monthly for the first 30 years?
13. A couple wishes to borrow money using the equity in their home for collateral. A loan company will loan them up to 70% of their equity. They purchased their home 10 years ago for $60,670. The home was financed by paying 15% down and signing a 15-year mortgage at 9% on the unpaid balance. Equal monthly payments were made to amortize the loan over the 15-year period. The net market value of the house is now $100,000. After making their 120th payment, they applied to the loan company for the maximum loan. How much (to the nearest dollar) will they receive?
Amount of loan: $_______
(Round to the nearest dollar.)
14. A person purchased a $236,124 home 10 years ago by paying 15% down and signing a 30-year mortgage at 9.9% compounded monthly. Interest rates have dropped and the owner wants to refinance the unpaid balance by signing a new 20-year mortgage at 5.4% compounded monthly. How much interest will refinancing save?
Money Saved: $______
(Round to the nearest cent as needed.)
15. A discount electronics store offers to let you pay for a $1000 stereo in 12 equal $87 installments. The store claims that since you repay $1044 in 1 year, the $87 finance charge represents a 4.4% annual rate. This would be true if you repaid the loan in a single payment at the end of the year. But since you start repayment after 1 month, this is an amortized loan, and 4.4% is not the correct rate. What is the annual nominal compounding rate for this loan? Use graphical approximation techniques or an equation solver to approximate the interest rate. Express the answer as a percentage.
The actual annual nominal compounding rate for this loan is_______%.
(Type an integer or decimal rounded to two decimal places as needed.)
