All Questions
Tagged with statistics excel
260
questions
0
votes
1
answer
88
views
Is there a way to apply R formula to whole excel sheet
I have the following code to apply in R:
qnorm(0.975)*sqrt(p*(1-p)/n)
Typically, I would enter the individual p and n values to get the output. However, I have a lot of data in Excel format, and to ...
- 21
0
votes
1
answer
65
views
How do I calculate weighted average of dates?
The context for this question is that say I have 200 dollars locked up that will be paid back to me each month for a varying amount of money with the final payment taking pace on the 4th year. I'm NOT ...
0
votes
0
answers
58
views
Weighted Standard Deviation on Excel Pivot Table
I have a dataset of investments with the following columns
Investment
Investment Rating
Commitment
Region
Portfolio
Helper
A
10
100
Asia
P1
1000
B
9
250
Africa
P2
2250
C
8
300
S. America
P1
2400
...
0
votes
1
answer
41
views
Counting the occurrence of a character based on whether there is a value in a different cell [closed]
I am trying to figure out how many games a team has played on the road already given their entire schedule. Using COUNT for the column (C) that contains "@" (that is the only value in the ...
0
votes
1
answer
161
views
TTEST and Data Analysis ToolPak give different p-values for t-test
My previous question was incorrectly closed, so I made a new post as I am unable to reopen it.
I'm trying to perform a t-test on the two pairs of means you can see in the images below - blue vs red, ...
- 74
0
votes
1
answer
48
views
Excel =TTEST and Data Analysis ToolPak give different p-values for t-test [closed]
I'm trying to perform a t-test on the two pairs of means you can see in the image below - blue vs red, two tailed, unpaired with unequal variance.
As you can see, the p-value returned by the Data ...
- 74
-1
votes
2
answers
67
views
Excel, how to have grouped TRIMMEAN
Hi i have dynamic data updated from remote every day of that type
state
city
id
number
s1
c1
i1
45
s1
c1
i2
2
s1
c2
i3
12
s2
c1
i4
23
s2
c4
i5
45
i need a result set with this structure
state
...
- 1,382
0
votes
0
answers
51
views
Python + Excel - deriving a correlated mean from 2 data groups?
What I'm doing - I have two columns in Excel: price and borough(British for district). I've generated the overall data set using python too, so I already have a list composed of the various boroughs. ...
- 13
0
votes
1
answer
115
views
Owen's T function in Excel
For context, I was trying to find a way to set the skewness of a distribution, leading me to the skew normal distribution which uses Owen's T in its cumulative distribution function. After searching ...
- 378
0
votes
1
answer
464
views
What is the difference between FORECAST.ETS function in Excel and Exponential Smoothing forecast in Data Analyst Tool Pack Excel?
In Excel 2016, there is a formula for forecast called FORECAST.ETS,
Whereas, there is also an Excel Adds-In Data Analyst for forecast called Exponential Smoothing.
Is it the same function or different?...
- 11
0
votes
0
answers
24
views
Should I use a t-test?
I am comparing two sets of samples that are of different sizes (n) and are from two different populations. Both sets have undergone a similar intervention at different time periods (one from August to ...
0
votes
1
answer
43
views
Excel vlookup for 2 different cell values [duplicate]
so i am doing a statistic's project and i need to combine the tables with one another since the tables do not have the same countries i need to use vlookup in excel to combine it
the main problem is: ...
- 7
0
votes
1
answer
112
views
R | Fisher test error is saying out of workspace?
I'm trying to compare two columns for significant association and thus am using a Fisher test as most cell values are 0. The first thing I did was create a 2x2 contingency table, but it is not correct,...
- 37
0
votes
1
answer
114
views
Correlation of 2 binary events over time in Excel
I need help determining if 2 events are related.
I have a light on in my back yard meant as a deterrent for deer eating things in my garden, but sometimes it goes off without warning. I have data by ...
- 21
0
votes
2
answers
47
views
R help, Getting my excel file loaded correctly
I have written this line of code
read_excel(path = "C:/users/irish/downloads/mis445googleamazonstock.xlsx", col_names = TRUE, col_types = NULL, na = "", skip = 0)
It pulls back ...
- 1