Anybody else having new (9/30/2018) problems with Analysis Toolpak in Excel 2013?

Copper Contributor

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 
BinFrequency BinFrequency
06446 06446
0.0304625850 0.0304625850
0.0609251690 0.0609251690
0.0913877540 0.0913877540
0.1218503390 0.1218503390
0.1523129240 0.1523129240
0.1827755080 0.1827755080
0.2132380930 0.2132380930
0.2437006782 0.2437006782
0.27416326210 0.27416326210
0.30462584713 0.30462584713
0.33508843217 0.33508843217
0.36555101620 0.36555101620
0.39601360123 0.39601360123
0.42647618626 0.42647618626
0.45693877127 0.45693877127
0.48740135529 0.48740135529
0.5178639429 0.5178639429
0.54832652529 0.54832652529
0.57878910928 0.57878910928
0.60925169428 0.60925169428
0.63971427926 0.63971427926
0.67017686324 0.67017686324
0.70063944824 0.70063944824
0.73110203321 0.73110203321
0.76156461819 0.76156461819
0.79202720217 0.79202720217
0.82248978715 0.82248978715
0.85295237214 0.85295237214
0.88341495612 0.88341495612
0.91387754111 0.91387754111
0.9443401268 0.9443401268
0.974802718 0.974802718
1.0052652957 1.005265295531
1.035727886 1.035727886
1.0661904654 1.0661904654
1.0966530495 1.0966530495
1.1271156343 1.1271156343
1.1575782193 1.1575782193
1.1880408033 1.1880408033
1.2185033882 1.2185033882
1.2489659731 1.2489659731
1.2794285582 1.2794285582
1.3098911421 1.3098911421
1.3403537271 1.3403537271
1.3708163121 1.3708163121
1.4012788961 1.4012788961
1.4317414811 1.4317414811
1.4622040660 1.4622040660
1.492666650 1.492666650
1.5231292351 1.5231292351
1.553591820 1.553591820
1.5840544050 1.5840544050
1.6145169891 1.6145169891
1.6449795740 1.6449795740
1.6754421590 1.6754421590
1.7059047430 1.7059047430
1.7363673280 1.7363673280
1.7668299130 1.7668299130
1.7972924970 1.7972924970
1.8277550820 1.8277550820
More1 More1

 

0 Replies