Excel> INTERCEPT ()> Intercept value> Web error> Confirm with python / _, _ with tuple

http://excel.onushi.com/function/intercept.htm The value of INTERCEPT () described in.

As a result, A4 returns the intercept value of the linear regression line, 3.2.

It is -3.2 when calculated by the function (C implementation) for finding the intercept that we have.

The signs do not match.

I also tried to solve python study (introduction to scipy) with python. Reference http://akiyoko.hatenablog.jp/entry/2013/06/16/005946

http://ideone.com/OVtvzj

from scipy import stats

xs = [ 5, 10, 9 ]
ys = [ 2, 7, 7 ]

slope, intercept, r_value, _, _ = stats.linregress(xs, ys)

print "slope:", slope
print "intercept:", intercept
print "r_value:", r_value

result


Success	time: 0.15 memory: 46904 signal:0
slope: 1.07142857143
intercept: -3.2380952381
r_value: 0.981980506062

The description on the web may be wrong, or the definition may be different. I was able to confirm that this C implementation function and python are consistent.

Digression

The last two of the python implementations slope, intercept, r_value, _, _.

http://docs.scipy.org/doc/scipy/reference/generated/scipy.stats.linregress.html It seems that pvalue and stderr are returned as tuples in the " _, _ " part. If you don't use it as a variable, you would write _.

http://stackoverflow.com/questions/2745018/python-is-there-a-dont-care-symbol-for-tuple-assignments

_ is indeed a very popular choice for "a name which doesn't matter" -- it's a legal name, visually unobtrusive, etc.

However, be careful about the "_" idiom in GNU gettext. This information is up to this point because it is not related to me yet.

Recommended Posts

Excel> INTERCEPT ()> Intercept value> Web error> Confirm with python / _, _ with tuple
Excel with Python
Handle Excel with python
Operate Excel with Python (1)
Operate Excel with Python (2)
Operate Excel with Python openpyxl
Web scraping with python + JupyterLab
Let's run Excel with Python
Web API with Python + Falcon
Error when playing with python
Web application with Python + Flask ② ③
Web scraping beginner with python
Streamline web search with python
Web application with Python + Flask ④
solver> Link> Solve Excel Solver with python
Web scraping with Python ① (Scraping prior knowledge)
Replace dictionary value with Python> update ()
Getting Started with Python Web Applications
Try singular value decomposition with Python
Web scraping with Python First step
I tried web scraping with python.
Monitor Python web apps with Prometheus
Get web screen capture with python
Create an Excel file with Python3
Let's play with Excel with Python [Beginner]
Handle Excel CSV files with Python
web coder tried excel in Python
Excel aggregation with Python pandas Part 1
WEB scraping with Python (for personal notes)
Getting Started with Python Web Scraping Practice
Draw Nozomi Sasaki in Excel with python
Quickly create an excel file with Python #python
Convert Excel data to JSON with python
Daemonize a Python web app with Supervisor
[Personal note] Web page scraping with python3
Excel aggregation with Python pandas Part 2 Variadic
Web scraping with Python ② (Actually scraping stock sites)
Download files on the web with Python
Horse Racing Site Web Scraping with Python
[Easy Python] Reading Excel files with openpyxl
[Python] A quick web application with Bottle!
Getting Started with Python Web Scraping Practice
Easy web app with Python + Flask + Heroku
Create Excel file with Python + similarity matrix
Run a Python web application with Docker
Let's make a web framework with Python! (1)
[Easy Python] Reading Excel files with pandas
Practice web scraping with Python and Selenium
Excel table creation with Python [Progress management table]
Easy web scraping with Python and Ruby
Let's make a web framework with Python! (2)
[For beginners] Try web scraping with Python
Error when installing a module with Python pip
AWS-Perform web scraping regularly with Lambda + Python + Cron
Find the mood value with python (Rike Koi)
Python Web Content made with Lolipop cheap server
Vienna with Python + Flask web app on Jenkins
Let's write FizzBuzz with an error: Python Version
Introduction to Tornado (1): Python web framework started with Tornado
[Python] How to read excel file with pandas
[Web development with Python] query is also redirect