As you change the selection, the line on the chart also change. Next, in the same ‘Design’ tab, select ‘Add Chart Element’, ‘Trendline’ and ‘More Trendline Options …’. Click on the ‘Design’ tab, the ‘Select Data’, then ‘Edit’ and switch around the data groups. However, the Objective Variable, which is the video duration, should be on the vertical axis, but here they are reversed. It seems that the data have a positive correlation. Simply select the source data and select ‘Insert’ and then in the ‘Charts’ section, select ‘Scatter’. Before doing a Simple Regression Analysis, it’s good to make a Scatter Plot first and visualize the data. Let’s do the Simple Regression Analysis with Excel. The Scatter Plot in Excel gives us a Simple Regression Equation and Coefficient of Determination. In fact, I divided today’s topic into three videos because of this equation’s result. The Multiple Regression Equation looks something like this:īecause I want my video to be about 5 minutes, I always check the video duration with this formula before I film my video and utilize the result to decide whether to add more content or sometimes divide the content into two videos. When there are two or more Explanatory Variables, we’ll use Multiple Regression Analysis.
In this example, since there is only one Explanatory Variable, it’s a Simple Regression Analysis. I can predict video duration quite accurately with this and it’s very helpful.
Lucidchart diagrams show regression analysis plus#
Also, the +35.5 portion is called an ‘Intercept’ and represents the value of Y when X is 0.įrom my equation, if the blog has 600 words: X is 600, 0.47 times 600 plus 35.5 equals 5 minutes 18 seconds. For my equation, if X increases by 1, Y increases by 0.47. The 0.47 portion is called a ‘Coefficient’ and represents the slope of the line of the Regression Equation. For my data, from the result of the Simple Regression Analysis, it became Y = 0.47 X + 35.5. This expression is called a ‘Regression Equation’. The video duration I wanted to predict is Y, which is called the ‘Objective Variable’ and the number of blog words is X that should be written as a factor and this is called an ‘Explanatory Variable’.įrom a Simple Regression Analysis, we can express the Objective Variable by the equation: Y = a X + b. I gathered ten sets of sample data of the number of words in past blog posts and their video durations. I wanted to predict video duration from the number of words on the blog post. First, I write a blog post and then make a video about the same topic. I regularly post articles on this blog site,, then make a video for YouTube. I thought that it’s easier to understand Simple Regression Analysis by learning from an actual experience that I had.
Regression Analysis already sounds complicated. It’s true for any data analysis, that you cannot stop with just making them.Ĭase study of the Simple Regression analysis Regression analyses give us good hints about the causes of the business activities and factors that affect those results. The real purpose of analyses is to use them for your future activities. That data is the result of your business activities.
These days, with the development of IT, most companies can gather a lot of data. 3rd Time = Multiple Regression Analysis.2nd Time = Simple Regression Analysis with the Excel Data Analysis Tools,.This time = Simple Regression Analysis with a Scatter Plot,.In order to answer his question, I have to explain the basics of Regression Analysis first, so I divided this topic into three videos. “Please explain Multiple Regression Analysis and correlation that can be used in business forecasting and customer satisfaction research analysis etc.” Hi, this is Mike Negami, Lean Sigma Black Belt.
0 kommentar(er)
