Questions tagged [statistics]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3 votes
4 answers
804 views

IE Browser Market Share: What Are the Real Statistics?

I was just looking at W3Schools and Wikipedia for browser share statistics, and they report drastically different numbers for IE, especially. I understand that for all surveys, there will be some ...
0 votes
0 answers
28 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
105 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 ...
0 votes
1 answer
178 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 ...
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 ...
25 votes
6 answers
19k views

Why do different manufacturers have different S.M.A.R.T value?

First of all, I think everyone knows that hard drives fail a lot more than the manufacturers would like to admit. Google did a study that indicates that certain raw data attributes that the S.M.A.R.T ...
0 votes
1 answer
717 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 ...
10 votes
2 answers
3k views

Long-term storage reliability of various media

I’m looking for a reference of statistics on long-term storage/archive reliability for various types of media. That is, I’m looking for information, comparisons, charts, graphs, test results, etc. on ...
1 vote
1 answer
426 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 ...
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....
2 votes
3 answers
4k 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 ...
0 votes
0 answers
404 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 ...
10 votes
5 answers
58k 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
1 answer
48 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
642 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).
1 vote
1 answer
108 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 votes
1 answer
27 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 ...
0 votes
2 answers
372 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 = ...
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
0 answers
472 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 ...
1 vote
2 answers
75 views

Measuring internet performance

Is there a program that measures the performance (bandwidth, latency) of my internet connection over time? I'm interested in trends, statistics, etc... I suspect that I'm not getting all that I'm ...
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 ...
10 votes
3 answers
11k views

Application to gather mouse usage statistics [closed]

Any application available to gather and analyze stats about mouse usage. For e.g.: Mouse movement speed, number of productive and unproductive clicks, etc. The more the analysis available the better....
0 votes
0 answers
51 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
3 votes
2 answers
1k 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 ...
1 vote
1 answer
54 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 ...
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 ...
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 ...
2 votes
1 answer
7k 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
1 answer
240 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 ...
3 votes
1 answer
2k 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 ...
0 votes
1 answer
762 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
0 answers
69 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 ...
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 ...
0 votes
1 answer
620 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:...
1 vote
1 answer
510 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
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
2k 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
1 answer
40 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
1 answer
305 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" ...
4 votes
3 answers
18k views

Graphing mean and standard deviation

I have measurements for multiple devices, and have their mean and sd values. I would like to produce a chart that would show these values, and I think the best would be if I could have something that ...
0 votes
1 answer
54 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
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) ...
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
52 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 ...
-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 =...
8 votes
6 answers
719 views

Is there a software that performs a textual analysis on blogs? [closed]

My company is looking to create a PivotViewer visualization of a client's Wordpress 2 blog posts for the last 11 years. To do so, however, we need to edit the somewhat haphazard, incomplete, and ...