{"id":3383,"date":"2022-11-25T12:44:29","date_gmt":"2022-11-25T12:44:29","guid":{"rendered":"https:\/\/www.iseepassword.com\/blog\/?p=3383"},"modified":"2023-10-10T10:48:47","modified_gmt":"2023-10-10T10:48:47","slug":"how-to-calculate-coefficient-of-determination-in-excel","status":"publish","type":"post","link":"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/","title":{"rendered":"how to calculate coefficient of determination in excel?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_69_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#How_do_I_calculate_R2_in_Excel\" title=\"How do I calculate R2 in Excel?\">How do I calculate R2 in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#How_do_you_calculate_the_coefficient_of_determination\" title=\"How do you calculate the coefficient of determination?\">How do you calculate the coefficient of determination?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#How_do_you_calculate_coefficient_of_determination_in_R\" title=\"How do you calculate coefficient of determination in R?\">How do you calculate coefficient of determination in R?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#What_is_r2_in_regression_formula\" title=\"What is r2 in regression formula?\">What is r2 in regression formula?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#What_is_the_difference_between_r2_and_correlation_coefficient\" title=\"What is the difference between r2 and correlation coefficient?\">What is the difference between r2 and correlation coefficient?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#Why_do_we_calculate_the_coefficient_of_determination\" title=\"Why do we calculate the coefficient of determination?\">Why do we calculate the coefficient of determination?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#Is_R2_same_as_coefficient_of_determination\" title=\"Is R2 same as coefficient of determination?\">Is R2 same as coefficient of determination?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#How_is_R2_value_calculated\" title=\"How is R2 value calculated?\">How is R2 value calculated?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#How_do_you_find_the_coefficient_of_determination_in_Excel_using_R_2\" title=\"How do you find the coefficient of determination in Excel using R 2?\">How do you find the coefficient of determination in Excel using R 2?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#How_do_you_manually_calculate_R2\" title=\"How do you manually calculate R2?\">How do you manually calculate R2?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#How_do_you_find_R_and_R2\" title=\"How do you find R and R2?\">How do you find R and R2?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#Is_R2_correlation_or_regression\" title=\"Is R2 correlation or regression?\">Is R2 correlation or regression?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#What_is_the_correlation_formula_in_Excel\" title=\"What is the correlation formula in Excel?\">What is the correlation formula in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.iseepassword.com\/blog\/how-to-calculate-coefficient-of-determination-in-excel\/#How_do_I_convert_R_to_R2\" title=\"How do I convert R to R2?\">How do I convert R to R2?<\/a><\/li><\/ul><\/nav><\/div>\n<p>The coefficient of determination is a measure of how well a linear regression model fits the data. It is calculated as the square of the correlation between the dependent variable and the predicted values from the regression model. <\/p>\n<p>To calculate the coefficient of determination in Excel, you can use the CORREL function. This function returns the correlation between two variables, and takes two arguments: The first argument is the array or range of data for the first variable, and the second argument is the array or range of data for the second variable. <\/p>\n<p>For example, if you have data for sales and advertising spending in two columns on your worksheet, you would use this formula to calculate the coefficient of determination:<br \/>\n=CORREL(sales,advertising)<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_do_I_calculate_R2_in_Excel\"><\/span>How do I calculate R2 in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_do_you_calculate_the_coefficient_of_determination\"><\/span>How do you calculate the coefficient of determination?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The coefficient of determination is a measure of how well a model explains the variation in a dependent variable. It is calculated as the square of the correlation between the dependent variable and the predicted values from the model.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_do_you_calculate_coefficient_of_determination_in_R\"><\/span>How do you calculate coefficient of determination in R?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The coefficient of determination is a measure of how well a model explains the variation in a dependent variable. It is calculated as the squared correlation between the observed values of the dependent variable and the values predicted by the model. In R, it can be calculated using the lm() function.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_is_r2_in_regression_formula\"><\/span>What is r2 in regression formula?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>R2, or the coefficient of determination, is a statistical measure that represents the percentage of variance in the dependent variable that is explained by the independent variable. In other words, it measures how well your model predicts the dependent variable based on the independent variable.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_is_the_difference_between_r2_and_correlation_coefficient\"><\/span>What is the difference between r2 and correlation coefficient?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The r2 value is a measure of how close the data are to the fitted line, while the correlation coefficient measures the strength and direction of a linear relationship.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Why_do_we_calculate_the_coefficient_of_determination\"><\/span>Why do we calculate the coefficient of determination?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The coefficient of determination, also known as the R-squared value, is a statistical measure that tells us how well our data fit a linear model. In other words, it tells us how well our data points fall on a straight line. The higher the R-squared value, the better our data fit the model.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Is_R2_same_as_coefficient_of_determination\"><\/span>Is R2 same as coefficient of determination?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>No, R2 is not the same as the coefficient of determination. The coefficient of determination is a measure of how well a model fits the data. R2 is a measure of how much variation in the dependent variable is explained by the independent variable.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_is_R2_value_calculated\"><\/span>How is R2 value calculated?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>R2 value is calculated by taking the square of the correlation coefficient.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_do_you_find_the_coefficient_of_determination_in_Excel_using_R_2\"><\/span>How do you find the coefficient of determination in Excel using R 2?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>1. Enter your data into Excel.<br \/>\n2. Select the data you want to use for the regression analysis.<br \/>\n3. Click on the &#8220;Data&#8221; tab and then click on &#8220;Data Analysis.&#8221;<br \/>\n4. Select &#8220;Regression&#8221; from the list of options and click &#8220;OK.&#8221;<br \/>\n5. Click on the radio button next to &#8220;Labels in first row&#8221; if your data has headers. Otherwise, leave this unchecked.<br \/>\n6. Make sure the correct variables are entered in the Independent(X) Variable Range and Dependent Variable Range boxes.<br \/>\n7. Click on the checkbox next to &#8220;Residuals&#8221; and then click &#8220;OK.&#8221;<br \/>\n8. The coefficient of determination (R 2 ) will be displayed in the output under the heading R-squared (Multiple R).<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_do_you_manually_calculate_R2\"><\/span>How do you manually calculate R2?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To calculate R2 manually, you will need to first calculate the sum of squares for both the model and the residuals. The sum of squares for the model is defined as:<\/p>\n<p>SSM = \u03a3(yhat \u2013 ybar)^2<\/p>\n<p>Where yhat is the predicted value and ybar is the mean of all values. The sum of squares for the residuals is defined as:<\/p>\n<p>SSR = \u03a3(y \u2013 yhat)^2<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_do_you_find_R_and_R2\"><\/span>How do you find R and R2?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To find R and R2, you first need to calculate the correlation coefficient. This can be done using Excel or a statistical software package. The correlation coefficient will tell you how strong the linear relationship is between two variables. R2 is simply the square of the correlation coefficient and tells you how much of the variation in one variable is explained by the other variable.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Is_R2_correlation_or_regression\"><\/span>Is R2 correlation or regression?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>R2 is a correlation coefficient that measures the strength of the linear relationship between two variables.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_is_the_correlation_formula_in_Excel\"><\/span>What is the correlation formula in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The correlation formula in Excel is =CORREL(array1, array2). This function returns the correlation coefficient of two data sets.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_do_I_convert_R_to_R2\"><\/span>How do I convert R to R2?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There is no direct conversion from R to R2. However, you can use a variety of statistical techniques to estimate the value of R2 from an existing R value. One common method is to square the R value to obtain an estimate of R2.<br \/>\n{&#8220;@context&#8221;:&#8221;https:\/\/schema.org&#8221;,&#8221;@type&#8221;:&#8221;FAQPage&#8221;,&#8221;mainEntity&#8221;:[{&#8220;@type&#8221;:&#8221;Question&#8221;,&#8221;name&#8221;:&#8221;How do you calculate the coefficient of determination?&#8221;,&#8221;acceptedAnswer&#8221;:{&#8220;@type&#8221;:&#8221;Answer&#8221;,&#8221;text&#8221;:&#8221;nnThe coefficient of determination is a measure of how well a model explains the variation in a dependent variable. It is calculated as the square of the correlation between the dependent variable and the predicted values from the model.&#8221;}},{&#8220;@type&#8221;:&#8221;Question&#8221;,&#8221;name&#8221;:&#8221;How do you calculate coefficient of determination in R?&#8221;,&#8221;acceptedAnswer&#8221;:{&#8220;@type&#8221;:&#8221;Answer&#8221;,&#8221;text&#8221;:&#8221;nnThe coefficient of determination is a measure of how well a model explains the variation in a dependent variable. It is calculated as the squared correlation between the observed values of the dependent variable and the values predicted by the model. In R, it can be calculated using the lm() function.&#8221;}},{&#8220;@type&#8221;:&#8221;Question&#8221;,&#8221;name&#8221;:&#8221;What is r2 in regression formula?&#8221;,&#8221;acceptedAnswer&#8221;:{&#8220;@type&#8221;:&#8221;Answer&#8221;,&#8221;text&#8221;:&#8221;nnR2, or the coefficient of determination, is a statistical measure that represents the percentage of variance in the dependent variable that is explained by the independent variable. In other words, it measures how well your model predicts the dependent variable based on the independent variable.&#8221;}},{&#8220;@type&#8221;:&#8221;Question&#8221;,&#8221;name&#8221;:&#8221;What is the difference between r2 and correlation coefficient?&#8221;,&#8221;acceptedAnswer&#8221;:{&#8220;@type&#8221;:&#8221;Answer&#8221;,&#8221;text&#8221;:&#8221;nnThe r2 value is a measure of how close the data are to the fitted line, while the correlation coefficient measures the strength and direction of a linear relationship.&#8221;}},{&#8220;@type&#8221;:&#8221;Question&#8221;,&#8221;name&#8221;:&#8221;Why do we calculate the coefficient of determination?&#8221;,&#8221;acceptedAnswer&#8221;:{&#8220;@type&#8221;:&#8221;Answer&#8221;,&#8221;text&#8221;:&#8221;nnThe coefficient of determination, also known as the R-squared value, is a statistical measure that tells us how well our data fit a linear model. In other words, it tells us how well our data points fall on a straight line. The higher the R-squared value, the better our data fit the model.&#8221;}},{&#8220;@type&#8221;:&#8221;Question&#8221;,&#8221;name&#8221;:&#8221;Is R2 same as coefficient of determination?&#8221;,&#8221;acceptedAnswer&#8221;:{&#8220;@type&#8221;:&#8221;Answer&#8221;,&#8221;text&#8221;:&#8221;nnNo, R2 is not the same as the coefficient of determination. The coefficient of determination is a measure of how well a model fits the data. R2 is a measure of how much variation in the dependent variable is explained by the independent variable.&#8221;}},{&#8220;@type&#8221;:&#8221;Question&#8221;,&#8221;name&#8221;:&#8221;How is R2 value calculated?&#8221;,&#8221;acceptedAnswer&#8221;:{&#8220;@type&#8221;:&#8221;Answer&#8221;,&#8221;text&#8221;:&#8221;nnR2 value is calculated by taking the square of the correlation coefficient.&#8221;}},{&#8220;@type&#8221;:&#8221;Question&#8221;,&#8221;name&#8221;:&#8221;How do you find the coefficient of determination in Excel using R 2?&#8221;,&#8221;acceptedAnswer&#8221;:{&#8220;@type&#8221;:&#8221;Answer&#8221;,&#8221;text&#8221;:&#8221;nn1. Enter your data into Excel.n2. Select the data you want to use for the regression analysis.n3. Click on the &#8220;Data&#8221; tab and then click on &#8220;Data Analysis.&#8221;n4. Select &#8220;Regression&#8221; from the list of options and click &#8220;OK.&#8221;n5. Click on the radio button next to &#8220;Labels in first row&#8221; if your data has headers. Otherwise, leave this unchecked.n6. Make sure the correct variables are entered in the Independent(X) Variable Range and Dependent Variable Range boxes.n7. Click on the checkbox next to &#8220;Residuals&#8221; and then click &#8220;OK.&#8221;n8. The coefficient of determination (R 2 ) will be displayed in the output under the heading R-squared (Multiple R).&#8221;}},{&#8220;@type&#8221;:&#8221;Question&#8221;,&#8221;name&#8221;:&#8221;How do you manually calculate R2?&#8221;,&#8221;acceptedAnswer&#8221;:{&#8220;@type&#8221;:&#8221;Answer&#8221;,&#8221;text&#8221;:&#8221;nnTo calculate R2 manually, you will need to first calculate the sum of squares for both the model and the residuals. The sum of squares for the model is defined as:nnSSM = u03a3(yhat u2013 ybar)^2nnWhere yhat is the predicted value and ybar is the mean of all values. The sum of squares for the residuals is defined as:nnSSR = u03a3(y u2013 yhat)^2n&#8221;}},{&#8220;@type&#8221;:&#8221;Question&#8221;,&#8221;name&#8221;:&#8221;How do you find R and R2?&#8221;,&#8221;acceptedAnswer&#8221;:{&#8220;@type&#8221;:&#8221;Answer&#8221;,&#8221;text&#8221;:&#8221;nnTo find R and R2, you first need to calculate the correlation coefficient. This can be done using Excel or a statistical software package. The correlation coefficient will tell you how strong the linear relationship is between two variables. R2 is simply the square of the correlation coefficient and tells you how much of the variation in one variable is explained by the other variable.&#8221;}},{&#8220;@type&#8221;:&#8221;Question&#8221;,&#8221;name&#8221;:&#8221;Is R2 correlation or regression?&#8221;,&#8221;acceptedAnswer&#8221;:{&#8220;@type&#8221;:&#8221;Answer&#8221;,&#8221;text&#8221;:&#8221;nnR2 is a correlation coefficient that measures the strength of the linear relationship between two variables.&#8221;}},{&#8220;@type&#8221;:&#8221;Question&#8221;,&#8221;name&#8221;:&#8221;What is the correlation formula in Excel?&#8221;,&#8221;acceptedAnswer&#8221;:{&#8220;@type&#8221;:&#8221;Answer&#8221;,&#8221;text&#8221;:&#8221;nnThe correlation formula in Excel is =CORREL(array1, array2). This function returns the correlation coefficient of two data sets.&#8221;}},{&#8220;@type&#8221;:&#8221;Question&#8221;,&#8221;name&#8221;:&#8221;How do I convert R to R2?&#8221;,&#8221;acceptedAnswer&#8221;:{&#8220;@type&#8221;:&#8221;Answer&#8221;,&#8221;text&#8221;:&#8221;nnThere is no direct conversion from R to R2. However, you can use a variety of statistical techniques to estimate the value of R2 from an existing R value. One common method is to square the R value to obtain an estimate of R2.&#8221;}}]}<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The coefficient of determination is a measure of how well a linear regression model fits the data. It is calculated as the square of the correlation between the dependent variable and the predicted values from the regression model. To calculate the coefficient of determination in Excel, you can use the CORREL function. This function returns [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[57],"tags":[],"class_list":["post-3383","post","type-post","status-publish","format-standard","hentry","category-excel"],"_links":{"self":[{"href":"https:\/\/www.iseepassword.com\/blog\/wp-json\/wp\/v2\/posts\/3383","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.iseepassword.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iseepassword.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iseepassword.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iseepassword.com\/blog\/wp-json\/wp\/v2\/comments?post=3383"}],"version-history":[{"count":2,"href":"https:\/\/www.iseepassword.com\/blog\/wp-json\/wp\/v2\/posts\/3383\/revisions"}],"predecessor-version":[{"id":11278,"href":"https:\/\/www.iseepassword.com\/blog\/wp-json\/wp\/v2\/posts\/3383\/revisions\/11278"}],"wp:attachment":[{"href":"https:\/\/www.iseepassword.com\/blog\/wp-json\/wp\/v2\/media?parent=3383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iseepassword.com\/blog\/wp-json\/wp\/v2\/categories?post=3383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iseepassword.com\/blog\/wp-json\/wp\/v2\/tags?post=3383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}