Multinomial logit model in Excel tutorial 2017-10-20. To activate the Multinomial Logit Model dialog box, start XLSTAT, then select the XLSTAT / Modeling data / Logistic regression for binary response data command, or click on the logistic regression button of the Modeling Data toolbar (see below). Logistic Regression calculates the probability of the event occurring, such as the purchase of a product. In general, the thing being predicted in a Regression equation is represented by the dependent variable or output variable and is usually labeled as the Y variable in the Regression equation.
Related Articles
- 1 Subtotal Columns in OpenOffice
- 2 Insert Tangents in Excel
- 3 Create a Descriptive Statistics Table in OpenOffice
- 4 Use Excel to Interpolate
A variable undergoing logistic growth initially grows exponentially. After some time, the rate of growth decreases and the function levels off, forming a sigmoid, or s-shaped curve. For example, an area's population increases at an exponential rate until limiting factors slow the growth. Eventually, growth stops altogether. All logistic functions take the form of N divided by the sum of 1 and Ae raised to the power of negative kx, where N, A, e and k are all constants. Excel calculates values following logistic growth and can chart them on a line graph.
1.
Type '=A1/(1+B1exp(C1D1))' without quotes into an Excel cell.
2.
Type the value of the function's 'N' constant into cell A1. For example, if you want to chart the growth function, type '1,800 ÷ (1 + 5,000 × e^-0.07x)' without quotes, where 'e' is the mathematical constant equaling 2.71828; enter '1800' into cell A1.
3.
Type the value of the function's 'A' constant into cell B1. With this example, enter '5000' into cell B1.
4.
Type the value of the function's 'k' constant into cell C1. Continuing the example, enter '0.07'
5.
Enter the lowest value of 'x' that your graph will track in cell D1. For example, if you will begin tracking the function at the graph's origin, type '0' into cell D1.
6.
Enter a function into cell D2 that describes the increments you want on your graph. For example, if the function tracks periodic population growth in a culture, where 'x' represents minutes, and you want to estimate the population every 20 minutes, type '=D1+20' without quotes into cell D2.
7.
Highlight the bottom right corner of cell D2. Click your mouse and drag this corner downward, extending the formula downward and producing the x-axis values for your chart.
8.
Repeat the previous step with the cell where you entered your formula. This produces your chart's y-axis values.
9.
Highlight the values that the previous step produced. Click 'Insert' in Excel's menu bar.
10.
Click 'Line' from the ribbon's 'Charts' tab. Select one of the '2-D Line' thumbnails that the drop-down box displays. Excel will plot your function's logistic growth on a chart.
References (2)
Resources (2)
About the Author
Ryan Menezes is a professional writer and blogger. He has a Bachelor of Science in journalism from Boston University and has written for the American Civil Liberties Union, the marketing firm InSegment and the project management service Assembla. He is also a member of Mensa and the American Parliamentary Debate Association.
![Logistic Logistic](/uploads/1/2/3/6/123614284/936805761.jpg)
Choose Citation Style
Menezes, Ryan. 'How to Plot Logistic Growth in Excel.' Small Business - Chron.com, http://smallbusiness.chron.com/plot-logistic-growth-excel-39372.html. Accessed 15 June 2019.
Menezes, Ryan. (n.d.). How to Plot Logistic Growth in Excel. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/plot-logistic-growth-excel-39372.html
Menezes, Ryan. 'How to Plot Logistic Growth in Excel' accessed June 15, 2019. http://smallbusiness.chron.com/plot-logistic-growth-excel-39372.html
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.
This type of statistical analysis (also known as logit model) is often used for predictive analytics and modeling, and extends to applications in machine learning. In this analytics approach, the dependent variable is finite or categorical: either A or B (binary regression) or a range of finite options A, B, C or D (multinomial regression). It is used in statistical software to understand the relationship between the dependent variable and one or more independent variables by estimating probabilities using a logistic regression equation.
![Regression Regression](/uploads/1/2/3/6/123614284/915764543.jpg)
This type of analysis can help you predict the likelihood of an event happening or a choice being made. For example, you may want to know the likelihood of a visitor choosing an offer made on your website — or not (dependent variable). Your analysis can look at known characteristics of visitors, such as sites they came from, repeat visits to your site, behavior on your site (independent variables). Logistic regression models help you determine a probability of what type of visitors are likely to accept the offer — or not. As a result, you can make better decisions about promoting your offer or make decisions about the offer itself.