Sep 30 2018 05:29 AM
Shortly after the latest Windows 10 update (week of 9/24/18), the Histogram function of Analysis Tookpak in my version of Excel (2013 Home/Student) became corrupted on my PC. This problem happened after an unexplained auto (forced) shutdown and auto reboot in file recovery mode while I was working on the spreadsheet. Most of the histogram output data after the corruption event is correct except the frequency for the mean bin value displays an incorrect number that is approximately the sum of all numbers in the frequency column. The error is consistent from one analysis to another.
I have not yet checked other features such as multiple linear regression.
Example below:
Before Corruption | After Corruption | |||
Bin | Frequency | Bin | Frequency | |
0 | 6446 | 0 | 6446 | |
0.030462585 | 0 | 0.030462585 | 0 | |
0.060925169 | 0 | 0.060925169 | 0 | |
0.091387754 | 0 | 0.091387754 | 0 | |
0.121850339 | 0 | 0.121850339 | 0 | |
0.152312924 | 0 | 0.152312924 | 0 | |
0.182775508 | 0 | 0.182775508 | 0 | |
0.213238093 | 0 | 0.213238093 | 0 | |
0.243700678 | 2 | 0.243700678 | 2 | |
0.274163262 | 10 | 0.274163262 | 10 | |
0.304625847 | 13 | 0.304625847 | 13 | |
0.335088432 | 17 | 0.335088432 | 17 | |
0.365551016 | 20 | 0.365551016 | 20 | |
0.396013601 | 23 | 0.396013601 | 23 | |
0.426476186 | 26 | 0.426476186 | 26 | |
0.456938771 | 27 | 0.456938771 | 27 | |
0.487401355 | 29 | 0.487401355 | 29 | |
0.51786394 | 29 | 0.51786394 | 29 | |
0.548326525 | 29 | 0.548326525 | 29 | |
0.578789109 | 28 | 0.578789109 | 28 | |
0.609251694 | 28 | 0.609251694 | 28 | |
0.639714279 | 26 | 0.639714279 | 26 | |
0.670176863 | 24 | 0.670176863 | 24 | |
0.700639448 | 24 | 0.700639448 | 24 | |
0.731102033 | 21 | 0.731102033 | 21 | |
0.761564618 | 19 | 0.761564618 | 19 | |
0.792027202 | 17 | 0.792027202 | 17 | |
0.822489787 | 15 | 0.822489787 | 15 | |
0.852952372 | 14 | 0.852952372 | 14 | |
0.883414956 | 12 | 0.883414956 | 12 | |
0.913877541 | 11 | 0.913877541 | 11 | |
0.944340126 | 8 | 0.944340126 | 8 | |
0.97480271 | 8 | 0.97480271 | 8 | |
1.005265295 | 7 | 1.005265295 | 531 | |
1.03572788 | 6 | 1.03572788 | 6 | |
1.066190465 | 4 | 1.066190465 | 4 | |
1.096653049 | 5 | 1.096653049 | 5 | |
1.127115634 | 3 | 1.127115634 | 3 | |
1.157578219 | 3 | 1.157578219 | 3 | |
1.188040803 | 3 | 1.188040803 | 3 | |
1.218503388 | 2 | 1.218503388 | 2 | |
1.248965973 | 1 | 1.248965973 | 1 | |
1.279428558 | 2 | 1.279428558 | 2 | |
1.309891142 | 1 | 1.309891142 | 1 | |
1.340353727 | 1 | 1.340353727 | 1 | |
1.370816312 | 1 | 1.370816312 | 1 | |
1.401278896 | 1 | 1.401278896 | 1 | |
1.431741481 | 1 | 1.431741481 | 1 | |
1.462204066 | 0 | 1.462204066 | 0 | |
1.49266665 | 0 | 1.49266665 | 0 | |
1.523129235 | 1 | 1.523129235 | 1 | |
1.55359182 | 0 | 1.55359182 | 0 | |
1.584054405 | 0 | 1.584054405 | 0 | |
1.614516989 | 1 | 1.614516989 | 1 | |
1.644979574 | 0 | 1.644979574 | 0 | |
1.675442159 | 0 | 1.675442159 | 0 | |
1.705904743 | 0 | 1.705904743 | 0 | |
1.736367328 | 0 | 1.736367328 | 0 | |
1.766829913 | 0 | 1.766829913 | 0 | |
1.797292497 | 0 | 1.797292497 | 0 | |
1.827755082 | 0 | 1.827755082 | 0 | |
More | 1 | More | 1 |