the data sets I am comparing have different data sets within them e.g. one set has 10 values, the other has 15 values and another having 22, how can I compare this data to find the p-value, as one way anova requires you to have the same number of data in each set
You should post a video of a step-by-step tutorial of the following problem: "Some first-time home buyers-especially millennials are raiding their retirement accounts to cover the down payment on a home. An economist is concerned that the percentage of millennials who will dip into their retirement accounts to fund a home now exceeds 20%. He randomly surveys 190 millennials with retirement accounts and finds that 50 are borrowing against them. a. Set up the null and the alternative hypotheses to test the economist's concern. b. Calculate the value of the test statistic and the p-value. c. Determine if the economist's concern is justifiable at α=0.05." I've seen the mathematical approach to solving this, but how about a solution in Excel "talk".
Ok my question is how exactly would you format a null hypothesis for this? I understand that the p-value shows a significance but a significance for what?
if the p-value is lower than 5%, the null hypotheses is rejected and NOT "the null hypothesis is significant". Stop teaching it wrong! where did you learn this???
A lot of people in RUclips teaching things that they don't fully understand, i feel bad also because i'm one of the victim, but it gives me a lesson to learn from many resources so that we can compare and create a conclusion which are true
Can you explain what this data table is about and what we are actually trying to figure out by this analysis here?
the data sets I am comparing have different data sets within them e.g. one set has 10 values, the other has 15 values and another having 22, how can I compare this data to find the p-value, as one way anova requires you to have the same number of data in each set
if i want to find out the p-value of each variable of research. Each variable has more than two questions so how to calculate each variable p-value?
You should post a video of a step-by-step tutorial of the following problem:
"Some first-time home buyers-especially millennials are raiding their retirement accounts to cover the
down payment on a home. An economist is concerned that the percentage of millennials who will dip
into their retirement accounts to fund a home now exceeds 20%. He randomly surveys 190 millennials
with retirement accounts and finds that 50 are borrowing against them.
a. Set up the null and the alternative hypotheses to test the economist's concern.
b. Calculate the value of the test statistic and the p-value.
c. Determine if the economist's concern is justifiable at α=0.05."
I've seen the mathematical approach to solving this, but how about a solution in Excel "talk".
I GET 0% THERE ON ONE OR TWO TAIL TEST THEN WHAT DOS IT MEAN FOR 540 SAMPLE 349 AND 191 HIGH AND LOW GROUP
Ok my question is how exactly would you format a null hypothesis for this? I understand that the p-value shows a significance but a significance for what?
which means hypthosis rejected
Can I determine p value for two separate variables perhaps I don't have a range
Thanks
i don’t have the data analysis button
download the analysis toolpak under file->option->add ins
This also works at google sheet dont worry guys
There is no data analysis Tab at my Excel !!!
you have to add it, its not on the stock excel
@@user-ej5so2sz4n how do you add it?
@@charlotteness5410 Go to file
Nice video.
Apko yeh ata h so help me please 🙏🏻
if the p-value is lower than 5%, the null hypotheses is rejected and NOT "the null hypothesis is significant". Stop teaching it wrong! where did you learn this???
A lot of people in RUclips teaching things that they don't fully understand, i feel bad also because i'm one of the victim, but it gives me a lesson to learn from many resources so that we can compare and create a conclusion which are true
Maybe the purpose of the video is to have created a video...
True
How to fix my P-value shows that #DIV/0!