All Questions
14 questions
0
votes
1
answer
53
views
Problems with a constant in regression analysis in Excel [duplicate]
I am using regression analysis in excel for a dataset. If I take into account the constant, then I get terrible r-squared values, but the indicators of t-statistics and p-values indicate that it is ...
2
votes
0
answers
28
views
Portion of variance explained by individual properties with ANOVA
I have used the ANOVA test to compare the expected values of three datasets. The data sets contain data about the lifespans of three brands of frying oils. I have used Excel to perform the test and I ...
- 123
1
vote
1
answer
325
views
Pre and Post Survey Analysis in ANOVA Excel
I have a small end size of 6 participants. They all took the pre and post survey that had 10 questions with ranges associated with them. I did not ID the participants. I am wondering how to plug this ...
- 11
0
votes
0
answers
350
views
how to run a two way ANOVA in excel on summary data: counts of consumers
I have a table of counts of consumers, and I would like to run a 2-way ANOVA on them. There are two factors, year and age-group. Please see the following table of data.
Although I usually have ...
- 75
0
votes
1
answer
76
views
Statistical analysis, repeated measures t test or anova? Trouble with input when running any test
I've tried using google sheets/excel, but I can't figure how to run a 2 factor without repetition ANOVA (if that's the appropriate test for this data set). I think it's the way I set the spreadsheet ...
0
votes
4
answers
16k
views
How to: Analysing 5-Point Likert Scale with ANOVA
I am very confused since I could not find an understandable answer for it:
I must analyse my Likert Scale data with ANOVA to get the significance (using the ANOVA is the requirement...).
I have to ...
1
vote
1
answer
172
views
Terminology Question (ANOVA/t-test) - With and Without Replication?
Coming from a Psychology background, I have always been taught statistics terms as "within subjects" and "between subjects". Now using excel I see they are using the terms Anova - 2 Factor With ...
- 71
0
votes
1
answer
161
views
ANOVA & Sums of Squares in Excel and R
In this simple dataset, I have bird populations from three watersheds. I am completing an ANOVA by hand and in R and comparing the outputs.
...
- 213
0
votes
1
answer
37
views
Which test do I use for comparing site differences with unequal sample sizes?
I have fish gene expression data from various contaminated and reference sites. We measured the expression of 4 thyroid hormones in each fish at 5 sites. Site 1 had the fewest fish of only 6. The site ...
1
vote
0
answers
145
views
ANOVA for ordinal predictor (in excel only!), and significance of assessing survival *given that an event occurred*
I have two predictor variable of interest - one continuous, and one nominal (lipid profile ratio as the continuous, and cardiac hypertrophy type as the nominal).
I also have an outcome of interest - ...
- 33
1
vote
1
answer
132
views
Testing for equal and unequal variance: How do I work out the alpha value so that I can use the right f-crit table?
I'm a stats noob and I'm following this guide on how to work out whether the variances in 2 samples I intend to use in a 2-sample t-test are equal.
In the video he refers to an f-crit table for Alpha ...
- 127
1
vote
0
answers
41
views
Calculate sum squares within treatment
I have a group of subjects treated with a drug formulation and a parameter is measured. The next week (period 2) same group of subjects is treated with the same drug formulation and the same parameter ...
- 11
11
votes
1
answer
76k
views
Calculate P value for the correlation coefficient
I would like to understand how people add the P value on a figure for means (Y axis) by age, volume or any other variable (x axis). How did they calculate the P value here?
Please check the following ...
- 819
4
votes
0
answers
5k
views
Exponential regression: calculating p-value and F significance
I have a set of independent data and dependent data $(X,Y)$, where I would like to do an exponential regression to obtain its p-value and significant $F$ (already obtained $R^2$ and also the ...
- 223