![]() And I get the same result shown in this article. I am using FORECAST.LINEAR Function to predict the percentage. I have calculated the percentage of people who still use masks when the number of Covid Cases becomes Zero. When the writer introduced us to the dataset, it was explicitly mentioned.Īnyway, I am introducing another method that may overcome your confusion. That’s what is calculated in those methods. I think you expected the calculation to find X Intercept for Y = 0. To demonstrate this point, this context considers a practical dataset where the percentage of people still using masks is calculated when the number of Covid Cases becomes Zero. This article is about finding an X intercept. In my view, you should reconsider what you have said. I went through this article and did not find any technical issues. Use the INTERCEPT and Trendline Equation methods if you just need to know the x-intercept quickly.ĭownload the following workbook for your practice from the following link.You must remember that all through the article, we have considered the X values of our data as the known_ys (and vice versa for Y values) of the Excel function or graph tool or the Data Analysis tool.Read More: How to Find Y Intercept in Excel In the following image, we have highlighted the x-intercept.From this report, you will get the x-intercept along with other statistics.The regression summary will be generated by ToolPak.Select where to place the Output Range ( in our case, the location is Cell F4).You will be back to the Regression window again.Select Input Y Range first, remember that you have to select your X-values here.From the Data Analysis options, select Regression and press OK.Go to the Data tab and click on Data Analysis from the Analysis group.Now you will have this feature on your Excel ribbon.Mark the Analysis ToolPak checkbox and press OK.A new window will pop up named Add-ins.Then go to the Add-ins section and select Excel Add-ins from the Manage drop-down.To enable the Data Analysis ToolPak, press ALT+F+T and get to the Excel Options window.The fourth option is using the Data Analysis ToolPak of Excel. Read More: How to Find Intercept of Two Lines in Excel And you will get an intercept in Cell C20 ( and a slope in Cell C19).Put this formula in Cell C19 and press ENTER.You will see that an equation appears in the chart area. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |