Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [statistics]

The tag has no usage guidance.

0
votes
0answers
7 views

How to calculate FMI for R^2 using mice package?

I am trying to get R^2 estimates using a multiple-imputed dataset using mice, but there seems to be a problem with the package. Every time I use pool.r.squared, the fraction of information missing due ...
0
votes
1answer
54 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 ...
0
votes
0answers
38 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
0answers
20 views

Mac Application/File Opening Statistics

I would like to write to a file the time when I launch or quit any application on my Mac (10.14). Or even better, I hope I could write to a file the time when I open or close any file. Even better, I ...
0
votes
0answers
21 views

Hourly/Daily Statistics from tcpdump (reading from file)

as I am monitoring a specific portion of the traffic in my network with tcpdump I want to build statistics on how much of this traffic has gone from source x to dest z during a defined time interval (...
0
votes
1answer
26 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:...
0
votes
0answers
28 views

statistical model for predicting water flow based on temperature, day of week, momentum in Excel?

I have a time series of amounts of water flowing on a given day and temperatures (both observed and predicted for next days). I am assuming that the water flow on a next day can be almost fully ...
0
votes
0answers
18 views

Kibana - How can I visualizie the number of running tasks

I'm experimenting with Kibana (ELK Stack) at the moment and I'm wondering whether or not this is possible: I have data which contains a timestamp which is the start of a task and a field which gives ...
1
vote
0answers
202 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
1answer
39 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 ...
0
votes
0answers
15 views

How does one find out what weight data was used in samples of same weighted averages?

How to find what weight was used in columns of weighted averages? (the column data is known, the weighted average for each column is known, the weights used are known to be the same for each column of ...
0
votes
1answer
42 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 ...
0
votes
0answers
26 views

How to create a one dimensional distribution chart in excel

I have a set of data that I would like to benchmark against a distribution set that I do not have access to. I know what the 10th, 50th, and 90th percentile numbers are. In this case 10th-5,218; 50th-...
3
votes
1answer
291 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 ...
0
votes
1answer
20 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:...
2
votes
1answer
63 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
1answer
17 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 ...
1
vote
1answer
33 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) ...
0
votes
0answers
16 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
1answer
47 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
2answers
1k 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 ...
-1
votes
1answer
22 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
vote
1answer
2k 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: ...
0
votes
1answer
90 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 ...
1
vote
1answer
530 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
1answer
152 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 ...
0
votes
0answers
206 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 ...
3
votes
1answer
274 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 ...
-1
votes
1answer
211 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
vote
1answer
237 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 ...
0
votes
1answer
30 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....
0
votes
1answer
44 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 ...
0
votes
1answer
58 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 ...
2
votes
2answers
1k 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 ...
0
votes
0answers
39 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 ...
1
vote
2answers
121 views

Find out network usage from router

I have a simple TP-LINK TL-WR841ND router and wanted to ask how can I find out the usage of the local network. I see there are received/sent Packets in wireless statistics, but am not sure what ...
1
vote
2answers
268 views

Laptop battery uptime monitor

Is there any way to measure what sort of uptime/active usage I get out of a given battery charge; that is, how long do I get actually using the laptop between full charges. I'd like it to be a ...
7
votes
3answers
36k views

How do I see the network adapter statistics in Windows 7?

I remember there was bytes/packets sent/received since connection established in the past but I cannot find it in the adapter properties now. BTW, when I hover over the network connection icon in ...
0
votes
2answers
134 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
0answers
74 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
2answers
1k 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 ...
0
votes
1answer
28 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 ...
0
votes
1answer
304 views

How can I measure disk writes per file/program over a long period of time

I have an SSD and a hard disk in one computer. I use mountpoints and symlinks to put write-heavy directories (e.g. Downloads) on the hard disk to save on wear on the SSD. I want to find out which ...
1
vote
1answer
881 views

Use LINEST on filtered data - Excel

I am trying to use the LINEST function and then filter the original data to reflect the subset I am interested in. Unfortunately LINEST always uses all originally defined data. Is there a way to ...
0
votes
2answers
527 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
1answer
45 views

Is there a system monitoring tool that lets me write complex queries against the data? [closed]

I am looking for a system stat collection tool that will let me write queries against the data collected. I am planning to answer questions like: what is the average load, over the last 30 days, on ...
0
votes
1answer
652 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-...
1
vote
1answer
185 views

Checking chrome url autocomplete prabability stats

I want to see the probability stats that chrome has for certain keywords I type in the ommnibox, but I can't remember the command used to do it. What I mean is, when I type "twi" it gives me a list ...
1
vote
1answer
765 views

How to fill in missing data series?

I have monthly water quality (Nitrate) measurements from July, 2005 till Oct., 2013 (84 measurements). However, there is no measurements from Oct., 2007 till June, 2009 (21 measurements). Could you ...
0
votes
1answer
592 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 ...