Questions tagged [statistics]
The statistics tag has no usage guidance.
100
questions
0
votes
1
answer
54
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 ...
- 8,874
0
votes
0
answers
21
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
110
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,020
1
vote
1
answer
154
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
220
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 ...
- 20.4k
0
votes
1
answer
44
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
489
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).
- 20.4k
1
vote
1
answer
66
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
24
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
304
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 = ...
- 137
0
votes
0
answers
375
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
711
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
0
votes
0
answers
35
views
Excel group "box with whiskers" chart by time
I am logging various data every five minutes from my broadband modem to learn how my devices behave over time. This results in a lot of data I would like to use Excel to analyze.
One piece of data ...
0
votes
1
answer
826
views
Alternative to MAXIFS function
I currently only have access to excel 2016 for a certain contract, I need to replace this formula
=maxifs($C$2:$C,$A$2:$A,$E2,ARRAYFORMULA(MONTH($B$2:$B)),$G2)
enter image description here
3
votes
2
answers
823
views
Libre Office - Single Column Pie Chart
I want to create a pie chart, for a single column that looks like this:
I tried to select the range, click on Insert -> Chart -> Pie-Chart, but regardless of what I try, I always get an empty ...
- 127
0
votes
2
answers
2k
views
Percentage Overlap of 95% confidence ellipses in a PCA plot
I've generated some plots with the below code:
#Remove group label from the dataframe
data_just_feats <- data[ , -which(names(data) %in% c("Group"))]
# Pca Plot
plot_1 <- autoplot(...
- 111
1
vote
1
answer
46
views
View historical record of applications used on a PC
I want to access the exact time at which I turned on/off a program on windows 10. How can I find such records?
e.g. "Word.exe is started at 09:10 and terminated at 12:03."
I cannot find this in the ...
- 215
1
vote
1
answer
1k
views
"Stretching/Shrinking" data to align it with other data with Excel preferably
Ok, so my question is simple but requires some background. I'm working on a paper regarding the effects on stock price from the index announcement to the effective day.
The time period varies each ...
- 11
0
votes
1
answer
99
views
awk,sed help needed for addressing density [duplicate]
We are doing a study on livability and quality of life in high-density cities pulling information from sources that, when crunched, can provide an insight into the density ratio of apartments so as to ...
- 121
0
votes
1
answer
220
views
Random Number Help - I have a confidence, max, and min, how should I do this?
For a class project, I need to create a list of 100 randomly simulated numbers, but I am struggling with the formula. According to the homework, I know that I am 95% confident that the range of the ...
0
votes
1
answer
41
views
Increase Pre-Populated Excel Spreadsheet by a Percentage
I have a complex spreadsheet given to me by the engineering dept.
I want to use this spreadsheet to model increases in productivity as follows:
I want to be able to insert a % value in a cell and ...
- 101
3
votes
1
answer
1k
views
Plot several time series "categories" for several groups
I have a process that starts with State0, and after some time gets to State1, State2, and so on. Let there be Group1, Group2, Group3, and so on. How can I plot each state for each group having x as ...
- 131
2
votes
3
answers
3k
views
Get count of file types in a directory
How can I get a file count given a directory grouped by file type? The output might look something like
.txt: 4
.png: 16
.jpg: 32
This probably isn't difficult to achieve with a script, but is there ...
- 131
0
votes
1
answer
586
views
USB test methodology and automation tools [closed]
I am charged with the task to design the architecture to stress (burn-in) test computer's USB ports. Requirements are not defined yet, and I have double complicated task - to define what to test and ...
- 161
0
votes
0
answers
66
views
Very High Correlations In Forex Data
I have a regression problem where I'm working on predicting future close price value change of a certain forex pair, mainly USDJPY, so I did the following:
Get the forex historical data of USDJPY ...
- 101
0
votes
1
answer
497
views
Exclude outliers from any excel formula (numbers)
I found a great way to exclude outliers from a statistical excel formula, that requires only one row, such as AVERAGE.
{=AVERAGE(IF(AC4:AC22<>"",IF(AC4:AC22>=138,IF(AC4:AC22<=144,AC4:...
- 111
1
vote
0
answers
1k
views
MS Excel Filter Chart Data Labels not updating with filter
I have a large table of data containing my x-axis data, a column of dates, a column of numbers, and a column of data labels. I have setup a pivot chart where the date is the filter and the data all ...
- 111
1
vote
1
answer
442
views
Quickly show Readability Statistics in Microsoft Word
Is there a quick way to show the readability statistics for Microsoft Word 2013 or 2016 documents, without having to correct them first?
I know how to enable the readability statistics so that they ...
- 807
0
votes
1
answer
58
views
data export from site is in lines, how to put it in table form
I exported some data from a nutritions tracking website to use in excel and eventually in SPSS for analysis. However the data is exported in lines/rows. I need it to be in table form so I can use it ...
3
votes
1
answer
1k
views
Counting pairwise combinations from many options in Excel
I have a large dataset of students and the classes they have taken. Each student has taken 12 to 18 of around 80 available classes. Using Excel (2013) I would like to find out, for any given pair of ...
- 163
0
votes
1
answer
38
views
How to modify data to make box plot?
My data is formatted like:
0:01:11 0:01:58 0:01:12 0:01:33 0:01:14
0:01:07 0:07:00 0:04:14 0:02:07 0:03:06
0:01:16 0:01:00 0:02:39 0:03:00 0:03:43
0:02:26 0:02:57 0:08:43 0:03:10 0:...
- 1
2
votes
1
answer
261
views
Calculating the average ("hitrate") of football results
I want to find the average (or the "hit rate") of World Cup football results. I have calculated 2 points for correct 1X2, and 3 points for correct 1X2 + correct score. So the hit rate should be "yes" ...
0
votes
1
answer
31
views
How to count the number of cell pairs containing x and y values larger/smaller than the mean in excel?
I have an excel spreadsheet with paired data for 105 different pairs. I'm trying to conduct a chi square test, but I first need to find frequencies for the number of pairs where x is greater than the ...
- 23
1
vote
1
answer
48
views
How are statistical maps made? [closed]
I see maps with all kind of statistics (gdp, population density, rain, exports, happiness) on the internet all the time. Usually they're only outlines (so they have no roads or buildings or whatever) ...
- 145
0
votes
0
answers
19
views
Summary web usage of each process
How I can check summary usage web of each process? I don't need summary of week or month etc. Only from start of a application. I would like to open application and application would be counting data ...
- 121
0
votes
1
answer
51
views
Excel Data Distribution
I have a machine that produce goods by work order generated from database. The quantity of goods per work order varies from 1 to 5,000. I am trying to analyze the efficiency of the machine as I think ...
3
votes
2
answers
4k
views
Calculate Median based on counts of value
I have data of how many of a specific CPU we have, and their CPU-marks. Based on this I wish to dynamically calculate Median and Quartile stats.
For example, I have a table that looks like
Name ...
- 183
-1
votes
1
answer
39
views
Excel 2016 getting statistics out of distribution of A B C
If i have a list of value groups of A and B. (example ? was equal to 1.2 in the morning (A), which became 1.7 in the evening (B)
And I need to divide them in groups of :
X = A < B
Y = A > B
Z =...
- 1
2
votes
1
answer
6k
views
How to draw the center of mass of a scatter plot in Excel?
I have created a scatter plot in Excel, and I'd like to be able to draw its center of mass (i.e. the point whose coordinates is the average of each series).
I am currently doing it using this trick:
...
- 148
0
votes
1
answer
392
views
OpenOffice calc colorize data points differently
I gathered some FTP file size statistics for my boss and I wondered if OpenOffice calc had the ability to colorize the data points differently. I want to color green the data points within one ...
- 199
2
votes
1
answer
1k
views
TP Link - data statistics resets after modem restart
I have TP Link - TL-WR841N / TL-WR841ND.
I want to track data usage per device on monthly basis. I have enabled data statistics on my modem. But the statistics are getting cleared after modem restart....
- 121
1
vote
1
answer
394
views
Getting per-user or per-command CPU/load information for Linux
I have a stock-standard LAMP stack running on a Centos 7 (Linux 3.10.0) machine. The Apache web server passes requests to run PHP files to a number of php-fpm processes, which run under different ...
- 11
0
votes
0
answers
376
views
Unable to plot a scatter plot in excel
I have taken integers from 1 to 100 as my total population set. Now I generated 5 random numbers (using =randbetween() command) and called it my sample 1. Similarly, I created 200 such samples. Now I ...
- 73
5
votes
1
answer
972
views
Line chart in LibreOffice - data in rows (type, x, y) rather than in a 2-input table
How do I create a line chart in LibreOffice Calc if the data is organised in 3-tuples rather than in a two-input table?
Example:
Banana Jan 10
Banana Feb 20
Banana Mar 30
Banana ...
- 51
-1
votes
1
answer
476
views
When using laptop for heavy duty statistical analysis is it more important to have highest possible RAM or fastest possible processor?
I'm starting a private equity company and need to buy a laptop that can perform heavy duty statistical analysis. I don't know if I should focus on finding a laptop with the highest possible RAM or a ...
- 1
1
vote
1
answer
260
views
CPU performance growth stagnates
I looked at this diagram and I am wondering me that the increasing of the CPU performance seems to stop although the transistor count is still increasing.
I mean what are the profts of the increasing ...
- 111
0
votes
1
answer
80
views
How to set all column types and measures simultaneously in SPSS?
I have over 150 different variables in my data set that when imported from a CSV file are assigned the incorrect type and measure. All data should be considered to be of type numeric and measure scale....
- 167
0
votes
1
answer
72
views
Statistics in excel including modified text values
I have a table in Excel (2013) that looks something like this:
V1 V2 V3 V4
2.1 300 40.5 6.89
6.9 204 <0.02 <0.001
<0.3 96 6.5 1.2
For each of the columns V1 ...
- 103
0
votes
1
answer
64
views
Excel - choosing numbers from bigger data set
I have a question about excel (hopefully on the right forum)
I have a data of 100 numbers in excel and I want to randomly choose 30 numbers with the fact that the same number is not chosen again (so ...
- 1
2
votes
2
answers
3k
views
What is MS Word counting or ignoring when it counts words in an open vs. closed file?
Sometimes I estimate and bill projects based on word counts, so knowing the actual count is important. If I knew what MS Word counted and did not count in an open vs. closed file, then I could choose ...
- 533