这是您在 Windows 11/10 PC 上执行回归分析的指南。(Regression Analysis)回归分析(Regression Analysis)是一种用于评估一组数据的统计技术。它用于确定数据集中一组两个或多个变量之间的关系。它基本上使您能够从数据集中分析重要和不重要的因素,然后做出相应的决定。现在,如果您想在不执行手动计算的情况下执行回归分析,这篇文章将为您提供帮助。
在本文中,我们将讨论在Windows 11/10 PC 上进行回归分析的不同方法。您无需手动执行任何操作。只需(Just)导入您的数据集,选择输入变量,然后可视化结果。使用上述方法,您可以执行线性、非线性、多重和更多回归分析。让我们现在详细检查方法!
您如何执行回归分析?
可以使用Windows 11/10中的Excel执行回归分析。您还可以使用第三方免费软件来计算回归分析。此外,您甚至可以借助专门的免费网站在线执行回归分析。我们在下面详细讨论了所有这些方法。所以,让我们结帐吧!
如何在Excel中进行(Excel)回归分析(Regression Analysis)?
通过启用加载项,您可以轻松地在Excel和其他版本中执行回归分析。这个加载项称为数据分析工具(Data Analysis ToolPak)包,它预装在Microsoft Excel 中(Microsoft Excel)。只需(Just)按照简单的步骤在Excel中启用此加载项,然后您就可以执行多个数据分析。我们已经讨论了在Microsoft Excel(Microsoft Excel)中进行回归分析的分步过程。您可以在下面查看。
相关阅读:(Related read:) 什么是数据分析,它的用途是什么?(What is Data Analytics and what is it used for?)
如何在Windows 11/10回归分析(Regression Analysis)
以下是可用于在Windows 11/10回归分析(Regression Analysis)的方法:
- 在Microsoft Excel(Microsoft Excel)中执行回归分析。
- 使用 JASP(Use JASP)或Statcato免费软件执行回归分析。
- (Perform)使用免费的网络服务在线执行回归分析。
让我们详细讨论上述方法!
1]在Microsoft Excel中执行(Perform)回归分析(Regression Analysis)
您可以使用Microsoft Excel(Microsoft Excel)应用程序执行回归分析。Excel中的专用数据分析工具(Data Analysis ToolPak)包插件可让您执行回归分析和其他一些数据分析。您必须手动启用此加载项才能使用其功能。让我们看一下使用Excel的Data Analysis ToolPak插件进行回归分析的过程。
如何在Microsoft Excel中执行(Microsoft Excel)回归分析(Regression Analysis):
以下是在Microsoft Excel(Microsoft Excel)中进行回归分析的主要步骤:
- 启动 Microsoft Excel 应用程序。
- 转到文件(File)>Options > Add-ins选项卡。
- 单击“开始”按钮。
- 启用Data Analysis ToolPak加载项并返回 Excel 的主屏幕。
- 导入(Import)您的数据集并选择具有因变量和自变量的输入数据。
- 移动到数据选项卡。
- 按数据分析按钮。
- 选择回归(Regression)并点击确定按钮。
- 输入(Enter)输入 X 和 Y 范围以及其他输出选项。
- 点击确定按钮查看回归分析结果。
现在让我们详细讨论上述步骤。
首先,启动Microsoft Excel应用程序,然后启用Data Analysis ToolPak插件。为此,单击 File > Options并转到加载项(Add-ins)选项卡。在这里,单击“管理 Excel 加载项(Manage Excel Add-ins)”选项旁边的“开始”按钮。然后,选中Data Analysis ToolPak插件复选框并按 OK 按钮启用它。
现在,从Excel或任何其他受支持的文件导入数据集,或者您可以创建新数据集。选择要执行回归分析的输入数据字段。
接下来,转到“数据(Data)”选项卡,然后单击“数据分析(Data Analysis)”按钮。
之后,从可用的数据分析工具中选择(Data Analysis)回归(Regression)选项,然后单击确定( OK)按钮。
然后,您需要输入要进行回归分析的输入 X(自变量)和 Y(因变量)范围。除此之外,您还可以选择残差选项,如标准化残差、线拟合图、残差图等。此外,还有一些其他选项,如正态概率、置信水平、标签等。
请参阅:(See:) 如何查看和跟踪 Excel 工作簿统计信息。(How to view and track Excel workbook statistics.)
配置所有上述选项,然后按 OK 按钮以可视化结果。
它显示回归统计,包括系数、标准误差、t Stat、P 值(P-value)、显着性 F、多重 R、标准误差、观察值、自由度、平方和、均方、F 值等。
您可以将结果保存在同一个Excel工作表中或打印结果。
同样,您还可以执行分析,包括ANOVA检验、协方差、描述性统计、指数平滑、傅里叶(Fourier)分析、直方图、移动平均、抽样、t 检验等。
阅读:(Read:) 如何在 Microsoft Excel 中使用 DATEVALUE 函数(How to use the DATEVALUE function in Microsoft Excel)
2]使用JASP(Use JASP)免费软件进行回归分析(Regression Analysis)
您可以使用第三方免费软件对一组数据执行回归分析。有几个免费软件可以让您进行数据分析。在这里,我们将使用名为JASP和Statcato的免费软件。使用这两个免费软件,您可以执行回归分析和许多其他数据分析:
- JASP
- Statcato
1] JASP
JASP是Windows 11/10专用的免费统计分析软件。使用它,您可以执行回归分析、描述性检验、T 检验、方差分析、频率检验、主成分分析、探索性因素分析、元分析、汇总统计、SEM、(regression analysis, descriptives tests, T-tests, ANOVA, frequency tests, principal component analysis, exploratory factor analysis, meta analysis, summary statistics, SEM,) 可视化建模(visual modeling,)和验证性因素分析(confirmatory factor analysis)。它提供了一个专用的回归,您可以在其中执行线性、相关和逻辑回归分析。让我们来看看如何。
以下是在JASP(JASP)中进行回归分析的主要步骤:
- 下载并安装 JASP。
- 启动软件。
- 导入您的数据集。
- 转到回归选项卡。
- 选择经典(Choose Classical)或贝叶斯回归类型。
- 选择因变量和自变量并自定义其他参数。
- 查看并导出结果。
现在让我们详细说明上述步骤!
首先,您需要在您的 PC 上下载并安装JASP免费软件。(JASP)然后,启动该软件的主GUI。
现在,转到三栏菜单并单击“打开(Open)”选项以从本地保存的Excel、CSV、TSV、ODS、TXT等导入数据集。您还可以从OSF(开放科学框架(Open Science Framework))帐户导入输入数据。除此之外,它还附带了几个示例数据集,您可以在研究和分析中使用它们。
接下来,移动到Regression选项卡并选择要执行的回归分析类型,例如Logistic、Linear或Correlation。
之后,选择因变量和自变量,然后配置多个其他选项,如方法、WLS权重、模型、方法规范或标准等。您还可以选择要在回归分析中计算的值,例如残差(Residuals)、R 平方变化、协方差(Covariance)矩阵、共线性(Collinearility)诊断、部分(Part)和偏相关、模型(Model)拟合等。此外,您可以使用计算的回归分析统计数据绘制各种图表,包括残差(Residuals)v/s 相关、残差(Residuals)v/s 协变量、残差(Residuals)v/s 直方图和其他一些图表。
当您配置所有上述参数时,它会在右侧部分显示回归分析。您可以将回归分析的结果导出为HTML或PDF文档。
它是执行回归分析等的最佳免费软件之一。您可以从jasp-stats.org(jasp-stats.org)下载这个方便的免费软件。
请参阅:(See:) 什么是数据挖掘?基础知识及其技术?(What is Data Mining? Basics and its Techniques?)
2] Statcato
您可以尝试执行回归分析的另一个免费软件是Statcato。它是一个免费的开源软件,用于执行统计分析。它允许您执行回归分析以及其他几种类型的数据分析。其中提供的一些数据分析方法包括假设检验(Hypothesis Tests)、方差分析(ANOVA)、描述性(Descriptive) 统计(Statistics)、正态性检验(Normality Tests)、样本(Sample Size)量、非参数检验等。
它可以让您执行线性回归(Regression)、多重回归(Multiple Regression)、相关矩阵(Correlation Matrix)、非线性回归(Regression)等。让我们看看如何使用这个软件。
这些是在Statcato(Statcato)中执行回归分析的主要步骤:
- 下载这个软件。
- 启动 Jar 文件。
- 导入或创建输入数据集。
- 转到统计菜单。
- 单击(Click)相关和回归(Correlation)选项(Regression)。
- 选择所需的回归类型。
- 选择(Choose)因变量和自变量。
- 查看并保存回归分析。
现在让我们详细讨论上述步骤!
首先,您需要从statcato.org下载这个免费软件。然后,解压缩下载的 zip 文件夹,然后运行可执行Jar文件。您需要在系统上安装Java才能使用此应用程序。
现在,打开一个包含输入数据集的文件,或者您也可以在其类似电子表格的界面中创建一组新数据。
接下来,转到统计(Statistics)菜单并单击相关和回归(Correlation and Regression)选项,然后选择要执行的回归分析类型。
之后,选择要进行回归分析的自变量和因变量并设置其他选项。然后,按确定按钮。
它将在专用窗口中显示回归分析结果。
回归分析主要包括回归方程、解释变异、不明变异、确定系数、估计(Coefficient)标准(Standard)误差、检验(Test)统计量、p值等统计量。
您可以复制结果或打印输出。
它是另一个很好的统计分析软件,可让您计算各种统计数据、执行数据分析和绘制不同类型的图表。
阅读:x
3]使用免费的网络服务在线执行回归分析(Perform Regression Analysis)
您还可以使用专门的免费网络服务在线执行回归分析。在这里,我们将使用名为 socscistatistics.com 的 Web 服务。它使您可以在线执行线性(Linear)和多元(Multiple)回归分析。除此之外,您还可以在此网站上找到其他统计工具,例如ANOVA检验、卡方计算器(Chi-Square Calculator)、符号检验计算器(Sign Test Calculator)、标准误差计算器(Standard Error Calculator)、T 检验(T-tests)等。
如何在线进行回归分析:
以下是使用 socscistatistics.com 在线执行回归分析的主要步骤:
- 打开网络浏览器。
- 导航到 socscistatistics.com 网站。
- 转到回归计算器页面。
- 输入因变量和自变量的值。
- 点击计算(Calculate)回归方程(Regression Equation)选项。
首先,启动网络浏览器并打开 socscistatistics.com。现在,您需要导航到“多元回归计算器(Multiple Regression Calculator)”或“线性回归计算器(Linear Regression Calculator)”页面,无论您要使用哪种回归分析技术。
接下来,在 X(独立)和 Y(依赖)列中输入相应的输入值。您还可以输入估计值。
之后,单击计算回归方程(Calculate the Regression Equation)选项。
然后它将在同一窗口中显示回归分析结果。
回归分析结果包括图形、回归方程、平方和、乘积和、平均值等。
就是这样!希望本指南可以帮助您找到合适的方法来对Windows 11/10上的数据集执行回归分析。
现在阅读:(Now read:)
How to perform Regression Analysis in Windows 11/10
Here is a guide for you to perform Regreѕsion Analysis on your Windows 11/10 PC. Regression Analysis is a statistical technique use to evaluate a set of data. It is used for determining the relationship between a set of two or more variables in a dataset. It basically enables you to analyze the important and unimportant factors from a dataset and then make a decision accordingly. Now, if you want to perform a regression analysis without performing manual calculations, this post will help you.
In this article, we are going to discuss different ways to do regression analysis on Windows 11/10 PC. You don’t need to do anything manually. Just import your dataset, select input variables, and visualize the results. Using the mentioned methods, you can perform linear, non-linear, multiple, and more regression analyses. Let us check out the methods in detail now!
How do you perform a Regression Analysis?
Regression analysis can be performed using Excel in Windows 11/10. You can also use a third-party free software that lets you calculate regression analysis. Additionally, you can even perform regression analysis online with the help of a dedicated free website. We have discussed all these methods in detail below. So, let us checkout!
How do I do Regression Analysis in Excel?
You can easily perform a regression analysis in Excel and other editions by enabling an add-in. This add-on is called Data Analysis ToolPak which is preinstalled in Microsoft Excel. Just follow the simple steps to enable this add-in in Excel and then you will be able to perform several data analyses. We have discussed step by step procedure to do regression analysis in Microsoft Excel. You can check it out below.
Related read: What is Data Analytics and what is it used for?
How to perform a Regression Analysis in Windows 11/10
Here are the methods that you can use to perform a Regression Analysis on your datasets in Windows 11/10:
- Perform a regression analysis in Microsoft Excel.
- Use JASP or Statcato freeware to perform regression analysis.
- Perform regression analysis online using a free web service.
Let us discuss the above methods in detail!
1] Perform a Regression Analysis in Microsoft Excel
You can perform a regression analysis using the Microsoft Excel application. A dedicated Data Analysis ToolPak add-on in Excel lets you perform regression analysis and some other data analysis. You will have to manually enable this add-in to use its functionalities. Let us have a look at the procedure to use Excel’s Data Analysis ToolPak add-in for regression analysis.
How to perform a Regression Analysis in Microsoft Excel:
Here are the main steps to do regression analysis in Microsoft Excel:
- Launch the Microsoft Excel app.
- Go to the File > Options > Add-ins tab.
- Click on the Go button.
- Enable the Data Analysis ToolPak add-in and go back to Excel’s home screen.
- Import your datasets and select input data with dependent and independent variables.
- Move to the Data tab.
- Press the Data Analysis button.
- Select Regression and hit the OK button.
- Enter input X and Y range and other output options.
- Tap on the OK button to view regression analysis results.
Let us discuss the above steps in detail now.
Firstly, launch the Microsoft Excel app and then enable the Data Analysis ToolPak add-in. For that, click on File > Options and go to the Add-ins tab. Here, click on the Go button present beside the Manage Excel Add-ins option. Then, select the Data Analysis ToolPak add-in checkbox and press the OK button to enable it.
Now, import your datasets from an Excel or any other supported file, or you can create a new dataset. Select the input data fields for which you want to perform regression analysis.
Next, go to the Data tab and then click on the Data Analysis button.
After that, select the Regression option from the available Data Analysis tools and click on the OK button.
Then, you need to enter the input X (independent variable) and Y (dependent variable) range for which you want to do regression analysis. Apart from that, you can also select residuals options like standardized residuals, line fit plots, residual plots, etc. Also, some other options like normal probability, confidence level, label, etc.
See: How to view and track Excel workbook statistics.
Configure all the above options and press the OK button to visualize the results.
It shows regression statistics including coefficient, standard error, t Stat, P-value, significance F, multiple R, standard error, observations, degrees of freedom, sum of squares, mean squares, F value, and more.
You can save the results in the same Excel worksheet or print the results.
Similarly, you can also perform analysis including ANOVA tests, covariance, descriptive statistics, exponential smoothing, Fourier analysis, histogram, moving average, sampling, t-test, etc.
Read: How to use the DATEVALUE function in Microsoft Excel
2] Use JASP freeware to perform Regression Analysis
You can use third-party freeware to perform regression analysis on a set of data. There are several free software that let you do data analysis. Here, we are going to use free software called JASP and Statcato. Using these two free software, you can perform regression analysis and many other data analyses:
- JASP
- Statcato
1] JASP
JASP is a dedicated free statistical analysis software for Windows 11/10. Using it, you can perform regression analysis, descriptives tests, T-tests, ANOVA, frequency tests, principal component analysis, exploratory factor analysis, meta analysis, summary statistics, SEM, visual modeling, and confirmatory factor analysis. It offers a dedicated Regression where you can perform linear, correlation, and logistic regression analysis. Let us find out how.
Here are the main steps to do regression analysis in JASP:
- Download and install JASP.
- Launch the software.
- Import your dataset.
- Go to the Regression tab.
- Choose Classical or Bayesian regression type.
- Select dependent and independent variables and customize other parameters.
- View and export the results.
Let us now elaborate on the above steps!
Firstly, you need to download and install JASP freeware on your PC. And then, launch the main GUI of this software.
Now, go to the three-bar menu and click on the Open option to import datasets from locally saved Excel, CSV, TSV, ODS, TXT, etc. You can also import your input data from your OSF (Open Science Framework) account. Apart from that, it comes with several sample datasets that you can utilize in your study and analyses.
Next, move to the Regression tab and select the type of regression analysis you want to perform like Logistic, Linear, or Correlation.
After that, select dependent and independent variables and then configure multiple other options like method, WLS weight, model, method specification or criteria, and more. You can also select the values that you want to compute in the regression analysis, such as Residuals, R squared change, Covariance matrix, Collinearility diagnostics, Part and partial correlations, Model fit, and more. Also, you can plot various graphs with calculated regression analysis statistics including Residuals v/s dependent, Residuals v/s covariates, Residuals v/s histogram, and some other graphs.
As you configure all the above-discussed parameters, it displays regression analysis in the right-side section. You can export the results of regression analysis to an HTML or PDF document.
It is one of the best free software to perform regression analysis and more. You can download this handy freeware from jasp-stats.org.
See: What is Data Mining? Basics and its Techniques?
2] Statcato
Another freeware that you can try to perform regression analysis is Statcato. It is a free and open-source software to perform statistical analyses. It allows you to perform regression analysis as well as several other types of data analyses. Some of the data analysis methods provided in it include Hypothesis Tests, ANOVA, Descriptive Statistics, Normality Tests, Sample Size, Non-parametric Tests, and more.
It lets you perform Linear Regression, Multiple Regression, Correlation Matrix, Non-Linear Regression, etc. Let us check out how to use this software.
These are the main steps to perform a regression analysis in Statcato:
- Download this software.
- Launch the Jar file.
- Import or create an input dataset.
- Go to the Statistics menu.
- Click on the Correlation and Regression option.
- Select the desired regression type.
- Choose dependent and independent variables.
- View and save regression analysis.
Let us discuss the above steps in detail now!
Firstly, you need to download this free software from statcato.org. Then, unzip the downloaded zip folder and then run the executable Jar file. You need to have Java installed on your system to use this application.
Now, open a file containing the input dataset or you can also create a new set of data in its spreadsheet-like interface.
Next, go to the Statistics menu and click on the Correlation and Regression option and then select the type of regression analysis you want to perform.
After that, choose the independent and dependent variable for which you want to do regression analysis and set up other options. Then, press the OK button.
It will display the regression analysis results in a dedicated window.
The regression analysis mainly includes statistics like regression equation, Explained variation, Unexplained variation, Coefficient of determination, Standard error of estimate, Test statistics, p-value, and more.
You can copy the results or take a printout.
It is another good statistical analysis software that lets you calculate various statistics, perform data analysis, and plot different kinds of graphs.
Read: x
3] Perform Regression Analysis online using a free web service
You can also perform regression analysis online using a dedicated free web service. Here, we are going to use this web service called socscistatistics.com. It lets you perform Linear and Multiple regression analyses online. Apart from that, you can also find other statistical tools on this website like ANOVA tests, Chi-Square Calculator, Sign Test Calculator, Standard Error Calculator, T-tests, and more.
How to perform regression analysis online:
Here are the main steps to perform regression analysis online using socscistatistics.com:
- Open a web browser.
- Navigate to the socscistatistics.com website.
- Go to the regression calculator page.
- Enter values for dependent and independent variables.
- Tap on the Calculate the Regression Equation option.
Firstly, launch a web browser and open socscistatistics.com. Now, you need to navigate to the Multiple Regression Calculator or Linear Regression Calculator page, whichever regression analysis technique you want to use.
Next, enter the respective input values in the X (independent) and Y (dependent) columns. You can also enter estimate values.
After that, click on the Calculate the Regression Equation option.
It will then display the regression analysis results in the same window.
The regression analysis results include a graph, regression equation, sum of squares, the sum of products, mean values, and more.
That’s it! Hope this guide helps you find a suitable method to perform a regression analysis for your datasets on Windows 11/10.
Now read: