Questions tagged [statistics]
The statistics tag has no usage guidance.
30
questions with no upvoted or accepted answers
3
votes
0
answers
1k
views
Getting i/o statistics of a process per file
I have a process of I would like to monitor the i/o with some precision. I know the PID, but I can't really control the way it is started (so I can't really put a pv-like command in between). What I ...
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....
1
vote
1
answer
116
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
...
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 ...
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 ...
1
vote
1
answer
427
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 ...
1
vote
1
answer
263
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 ...
1
vote
2
answers
403
views
How can I track internet upload/download on linux while ignoring local traffic?
I have two Linux boxes connected to a router and the router is connected to a modem. The Linux computers share file systems via NFS. I want to track internet usage upload and download values, ...
1
vote
0
answers
93
views
How to add metadata (source of the dataset) to a file (dataset)?
I usually have to download datasets from websites through a point-and-click system that is difficult to replicate in a Makefile. In these cases, I want to include as much metadata about how I ...
1
vote
2
answers
2k
views
Stats on /proc/diskstats always shows more writes than reads
I've taken the following stats from /proc/diskstats:
9 0 md0 106989 0 _2923830_ 0 117988 0 _3448953_ 0 0 0 0
8 0 sda 33840 22299 _1143351_ 871132 87336 194804 _2003961_ 2201868 0 949992 ...
1
vote
1
answer
38
views
Linux program used to gather installed packages, processes, listening ports, etc.?
It's hard to Google this because it seems like everyone and their kid sister has written a script to gather system stats!
I once saw a mature program written that is used to gather system stats like ...
1
vote
1
answer
3k
views
Is there a way to log and view application run time statistics in Windows 7?
I'm looking for a way to collect stats on what apps are launched when and for how long they're used on my Windows 7 PC. Is there a native tool for that? If there is not, what are the popular third-...
0
votes
0
answers
36
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 ...
0
votes
0
answers
28
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
0
answers
423
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 ...
0
votes
0
answers
482
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 ...
0
votes
0
answers
55
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
1k
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
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(...
0
votes
1
answer
245
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
51
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 ...
0
votes
0
answers
70
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 ...
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 ...
0
votes
1
answer
53
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 ...
0
votes
0
answers
384
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 ...
0
votes
0
answers
49
views
What is the easiest way to generate a pi diagram or bar diagram from raw data?
Background:
I want to see an statistics on my spent time in several categories like sports, study, movie etc. throughout a certain period of time.
To visualize it, I have to represent it in pi diagram ...
0
votes
2
answers
1k
views
Finding trends in multi-category data in Excel
I have an Excel spreadsheet that contains hundreds of rows of data that each represent a single sample in a larger population. Each row is divided into three columns that contain frequency counts of ...
0
votes
1
answer
693
views
Excel: extrapolating data by group into the same column
I am trying to extrapolate baseline age into the remainder of the columns, for each participant.
See here, it's much clearer:
Essentially, I need to put 45 into the remaining ID = 40 rows, and ditto ...
-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
votes
1
answer
503
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 ...