Questions tagged [statistics]
The statistics tag has no usage guidance.
103
questions
0
votes
1
answer
40
views
Which correlation coefficient does Excel's CORREL() compute?
Which correlation coefficient does Excel's CORREL() compute? Is it Pearson correlation, Spearman correlation, or something else? The official doc doesn't say.
- 21.8k
0
votes
0
answers
66
views
How can I open SPSS data file that appeared the dialogue as the specified file is empty "
I can't open my SPSS data file due to the error which show "the specified file is empty".
It happened after window was shut down suddenly from electricity probably. But I still can see this ...
2
votes
3
answers
125
views
Weighted harmonic mean that ignores #DIV/0
I have this values:
Dataset: I have a row in a sheet (AQ4:KK4) with 255 values. The dataset have some 0 values.
Weights: I have a column in another sheet (L3:L257), also 255 values. Weights are never ...
- 23
0
votes
1
answer
301
views
Create a box-and-whisker plot for (category, value) categorical data?
In MS Excel (and LO Calc), you can easily create a box-and-whisker plot if your data is arranged like so:
foo
bar
baz
1
78
634
4
56
449
9
34
315
16
21
809
and you'll get three boxes, one for ...
- 9,854
0
votes
0
answers
44
views
Assigning values for a scorecard
I am generating a scorecard with the KPIs being scored from a scale of 1 - 5, 5 being the highest and 1 as the lowest. One of the KPIs is billable hours and I have a dataset from billable hours from ...
0
votes
1
answer
989
views
Performing T-test on subset of values in a Google Sheets range
I have a set of sports scores in Google Sheets. I have various subsets of scores for which I calculate the averages and standard deviations. I want to perform T-tests to determine if a particular ...
- 1,030
1
vote
1
answer
516
views
Create scatter plot using two arrays of data in Excel [duplicate]
I'm an aspiring eSports rookie who has been tracking his training progress for some time now. I have two tables in an Excel worksheet: The first is Accuracy, with rows being date and columns being ...
- 13
0
votes
0
answers
508
views
How can I see the transfer details when copying files from some external devices connected via USB with MTP (phone/GoPro) to some disk on Windows 10?
I don't see any transfer details when copying files from some external devices connected via USB with MTP (e.g., a phone or a GoPro) to some disk on Windows 10:
Typically I see transfer details:
How ...
- 21.8k
0
votes
1
answer
52
views
I'm having issue with counting with multiple criteria
Excel work screenshot:
I need to count the amount of blank cells in "days utilized" judging by the year "2009" in "year started" row. The answer is 1, but I didn't get ...
0
votes
1
answer
759
views
When opening a plain text file with Chrome, how can I know how many lines the text contains?
I'd prefer not having to copy the text to another program, as it may be very large (example).
- 21.8k
1
vote
1
answer
180
views
Calculating correlations on a variable across different locations [Panel/longitudinal data]
Hello I am trying to find the correlations between variables in excel.
My data is structured as follows across different sheets,
Location
Variable
Year 1
Year 2
Year 3
Place A
Indicator 1
1
2
3
...
- 11
-1
votes
1
answer
28
views
Am I doing this right? Comparing the mean and countIF for the likert-scale results
I have these for the likert scale
Likert scale range
When I calculated for the mean, it shows a value for 4.3 which means, this will be under the "Agree". But then, if I'll do a COUNTIF, it ...
- 103
0
votes
2
answers
401
views
Normal equation in Excel (statistics)
I'm attempting to learn about statistics in the infrastructure asset management industry.
I have an existing exponential regression equation that is used to find the condition of a given asset:
Y = ...
- 157
0
votes
0
answers
563
views
Microsoft Clarity: Why “Unique users” is greater than “Total sessions”
This image is screenshot of my Microsoft Clarity panel. As you see, "Distinct users" number is greater than "Total sessions" number!
Is this a bug or there is something else that ...
- 141
0
votes
1
answer
1k
views
How to find and highlight values outside two standard deviations for multiple measurement/std dev sets
So I know about conditional formatting and countif type ways to do this, but they won't work with my scenario. I have 120 rows with 3 measurements per row. With those three measurements I have an ...
- 3