How would I go about charting this in Excel. I'm having trouble on which data I need to select out of the first table in order to make the chart in the picture look the same as in the other picture. Discount rate8%Assume the project is completed in Year 0Year13 TotalCosts140,000 40,000| 40,000| 40,000|Discount factor0.930.860.79Discounted costs140,000 37,200| 34,400| 31,600 243,200|O 200,000 200,000 200,000|0.790 186,000 172,000 158,000 516,000BenefitsDiscount factor0.930.86Discounted benefitsDiscounted benefits - costs (140,000) 148,800 137,600 126,400 272,800 NPVCumulative benefits - costs (140,000) 8,800 146,400 272,800ROI112%Payback in Year 1 Payback600,000-500,000-400,000-Payback$ 300,000 -200,000 -100,000-12Year- Cumulative costs Cumulative benefits

Answered: Image /qna-images/answer/da89f1bd-c651-4c7e-bbd6-4498d3d78e73.jpg

Discount rate 8% Assume the project is completed in Year 0 Year 1 2 3 Total Costs Discount factor Discounted costs 140,000 40,000 40,000 40,000 0.79 1 0.93 0.86 140,000 37,200 34,400 31,600 243,200 Benefits 0 200,000 200,000 200,000 Discount factor 1 0.93 0.86 0.79 Discounted benefits 0 186,000 172,000 158,000 516,000 Discounted benefits - costs (140,000) 148,800 137,600 126,400 272,800 NP Cumulative benefits - costs (140,000) 8,800 146,400 272,800 ROI 112% Payback in Year 1

Discount rate 8% Assume the project is completed in Year 0 Year 1 2 3 Total Costs Discount factor Discounted costs 140,000 40,000 40,000 40,000 0.79 1 0.93 0.86 140,000 37,200 34,400 31,600 243,200 Benefits 0 200,000 200,000 200,000 Discount factor 1 0.93 0.86 0.79 Discounted benefits 0 186,000 172,000 158,000 516,000 Discounted benefits - costs (140,000) 148,800 137,600 126,400 272,800 NP Cumulative benefits - costs (140,000) 8,800 146,400 272,800 ROI 112% Payback in Year 1

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

What would the revenue function be
Sarah was calculating the speeds (mph) of vehicles travelling down Maple Street on two separate days at 9 am for an hour. Below is the data she collected. Wednesday's Speeds: Sunday's Speeds: 34,28,24,17,39,44,64,33,27,21,38,40,60,30,25,37,30,25,35,30 18,27,34,37,49.55,63,61,48,30,27,17,17,15,26,46,25 4) Find the Standard Deviation of each day. Wednesday's Standard Deviation Table X x (x-)²2 n-l Sunday's Standard Deviation Table 7 (x-2)² n-1 2). Sketch Wednesday's Bell Curve with 30 Sketch Sunday's Bell Curve with 30 (x-7)²= x-F (x-7) 2 3. Based on your analysis of the data and standard deviations, which day would you say is the most dangerous day on Maple Street?
This value represents how much a change in one variable can be predicted from its relationship witha completely different variable .......
Make a scatterplot of the untransformed data and tell which kind ofrelationship the points seem to follow. Also name the best type oftransformation needed to "straighten" the plot.Note: Part of the transformation shouId involve subtracting 1900 from the year soyou're working with more manageable numbers.Now try some transformations to get the data as close to linear as possible.(Use your calculator to transform the data, and try scatterplots of the differenttransformations). Then find the regression line, r, and r2.Tell which transformation worked the best and back it up by showing:• A scatterplot of the transformed data with the least-squares regression equation andline, r, and r-squared.• A plot of the original data with the regression equation converted to a non-linearequation
In an area of the Great Plains, records were kept on the relationship between the rainfall (in inches) and the yield of wheat (bushels per acre). The table shows the number of inches of rainfall and the yield (in bushels per acre). Use for problem #17 and #18. Rainfall (in inches), x 9.8 8.1 12.7 11.8 18.1 9.6 6.3 14.9 15.3 Yield (bushels per acre), y 48.5 44.2 56.8 57 80.4 47.2 29.9 74 76.8 17. Compute the linear correlation coefficient between the two variables above. (Round to thousandths.) 18. Determine whether a linear relation exists. (Show work to justify answer.)
With the rise of e-books and online retailers, the demand for physical bookstores has been declining. The number of bookstores from 2008 through 2013 (in hundreds) are shown in the following table (x = 0 corresponds to 2008): Year 0 1 2 3 4 5 Number of Bookstores 4.2 3.8 3.4 3.0 2.6 2.2 Using the equation, estimate the number of bookstores in 2016. Group of answer choices 200 300 100 400
The following data was collected to explore how the number of square feet in a house, the number of bedrooms, and the age of the house affect the selling price of the house. The dependent variable is the selling price of the house, the first independent variable (x1�1) is the square footage, the second independent variable (x2�2) is the number of bedrooms, and the third independent variable (x3�3) is the age of the house. Effects on Selling Price of Houses Square Feet Number of Bedrooms Age Selling Price 11191119 33 33 100900100900 13081308 33 44 119800119800 14521452 33 66 189800189800 16931693 33 66 190500190500 20052005 33 66 196900196900 22102210 33 99 216600216600 23012301 44 99 250900250900 23452345 44 1010 267800267800 28532853 55 1313 270000270000 Copy Data Step 1 of 2 : Find the p-value for the regression equation that fits the given data. Round your answer to four decimal places
Jane collects data from 40 elementary school students and finds that the relationship between age (x) and score on a certain test (y) is given by y=3.2x+45. What can she extrapolate about the score a 16-year old will get on the test?
You collect data of average annual returns for Amazon Stock and Microsoft Stock and make the following table: (This data can be copied into Excel.) You use this data to answer the research question: are true population Amazon Returns greater than true population Microsoft Returns? What is your point estimate of the difference in Amazon Returns and Microsoft Returns? Enter your answer as a positive number. Round your answer to four decimal places.
(For Questions 17-19 and 20-24). The following data was collected from a clinical trial testing a new drug aimed to lower blood pressure for individuals older than age 45. Half of the 20 participants received the new drug (Treatment = Yes) and the other half of the participants received a placebo pill (Treatment = No). Their age and gender was also recorded. Please use this data for Questions 17-19 and 20-24 and note, not all the information in the table will be used for either problem, you must decide what is relevant based on what the problem is asking. Subject ID Treatment Age Gender BP_Before BP_After D1 Yes 65 F 103.3 80.5 D2 Yes 59 F 93.6 85.9 D3 Yes 60 M 92 85.2 D4 Yes 54 F 93 87.8 D5 Yes 65 F 95.4 85.3 D6 Yes 57 M 109.6 94.2 D7 Yes 69 M 97.9 83.9 D8 Yes 62 M 96 85 D9 Yes 49 F 98.4 86.3 D10 Yes 45 M 98.4 90 C1 No 63 F…
The marching band at a local high school is selling candy bars. The profits will go toward the purchase of new marching band uniforms. They are interested in knowing what price they should charge to obtain the maximum profit. The candy bars are donated by a local retailer so they know that if they charge $0 they will make $0 profit. They also collect data from other marching bands who have sold candy bars in the past. The data they collected is shown in the table below. Price 0.00 0.45 0.60 0.75 1.00 1.25 1.40 1.50 Profit 0.00 $720 $900 $990 $845 $625 $560 $300 What factors might influence how much is to be made from the candy sale? Give at least two. What happens to the profit as the price of each candy bar increases? Explain possible reasons for your observations. How do you suppose the other bands determined the price at which to sell each candy bar? Do any data values seem unusual? Yes or…