All Questions
Tagged with excel multiple-regression
10 questions
1
vote
1
answer
38
views
What is the best model for this case?
I have the following problem:
A data set, which is about the soft drink consumption of people, that
covers 300 subjects are available to us. Using Excel tabulations and
graphing capabilities only:
...
- 103
0
votes
0
answers
29
views
Can I do a multiple linear regression analysis with a mixture of raw data and index data?
I'm trying to do a multiple linear regression analysis in Excel using the Analysis Toolpak and I am not good at math, let alone stats. So please excuse my total ignorance. I'm using the following ...
- 1
0
votes
0
answers
28
views
What kind of regression to use in predictive model for a positive-only value
I'm trying to use regression in Excel to predict the % of bin contamination (dependant variable), based on my independent variables that are generally relating to demographics such as age/household ...
- 1
1
vote
0
answers
130
views
How to use linear regression to determine if a significant difference exists?
I have two groups of data on students who took a course over the past year; one group online-only and the other face to face. Each student took two tests: a mid-year test and an end-year test, and ...
- 77
0
votes
0
answers
185
views
How to replicate the predict function from R in Excel given I have access to "summary" output from R
I have run a 3rd order polynomial regression in R and have run the "summary" function, but I need to be able to replicate the "predict" function in Excel. I have my current working code below. Thank ...
0
votes
1
answer
3k
views
Cross sectional regression in excel [closed]
Hi Can someone please let me know whether cross sectional regression is possible in Excel?
I'm trying to evaluate CAPM from MacBeth regression.
I need to run the cross sectional regression, but ...
- 155
1
vote
0
answers
261
views
Multiple regression with negative coefficient for Sales vs Revenue
Hi I have a table of data with 3 columns: Sales,Cancels and Net revenue.
I am triying to perform a Linear regression to check how much the sales and cancels affect the Net Rev but the first thing i ...
- 111
0
votes
0
answers
33
views
Smaller p-values on a selective multiple regression analysis [duplicate]
When I run a multiple regression analysis in Excel on 20 independent variables and 1 dependent variable (in two goes), I obtain in the summary a set of p-values. When I select the (six) ones that are ...
- 503
0
votes
2
answers
4k
views
How to do multiple regression with limited experience and (hopefully) excel?
I am doing a study of how legal need relates to a number of predictors.
Outcome Variable: Legal Need (Yes or No)
Possible Predictors: Age, Gender, Race, Ethnicity, Language, Clinic, Insurance ...
- 9
6
votes
3
answers
11k
views
Performing multiple linear regressions, in Excel, that have a common x-intercept?
I was plotting some linear data sets in Excel, including linear trend-lines:
I was about to perform 5 separate linear regressions, so I could get the slope and <...
- 1,446