I'm trying to use the correlation function in analysis toolpak but I keep getting "INPUT RANGE CONTAINS NON-NUMERIC DATA". I've used the =SUMPRODUCT(--NOT(ISNUMBER(range))) function for the columns I want to check, and all columns I want to use have turned up 0 but unfortunately I am still getting "INPUT RANGE CONTAINS NON-NUMERIC DATA". Ideas?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
INPUT RANGE CONTAINS NON-NUMERIC DATA but all columns show no existing non-numeric data
- Thread starter winds
- Start date
Excel Facts
Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
awoohaw
Well-known Member
- Joined
- Mar 23, 2022
- Messages
- 5,096
- Office Version
- 365
- Platform
- Windows
- Web
this is what I see when I paste (Just a small sample), except the cell width is much narrower:
| Mr Excel Questions.xlsx | |||
|---|---|---|---|
| A | |||
| 2 | 4072.53663.893293.752576292379.31211886342264.712.71520221333433333333343344444433344333333333333333333443333333333433344333443333333434333333 | ||
| 3 | 34 | ||
| 4 | 14 | ||
| 5 | 16 | ||
| 6 | 3 | ||
Sheet2 | |||
Upvote
0
| test.xlsx | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | BI | BJ | BK | BL | BM | BN | BO | BP | BQ | BR | BS | BT | BU | BV | BW | BX | BY | BZ | CA | CB | CC | CD | CE | CF | CG | CH | CI | CJ | CK | CL | CM | CN | CO | CP | CQ | CR | CS | CT | CU | CV | CW | CX | CY | CZ | DA | DB | DC | DD | DE | DF | DG | DH | DI | DJ | DK | DL | DM | DN | DO | DP | DQ | DR | DS | DT | DU | DV | DW | DX | DY | DZ | EA | EB | EC | ED | EE | EF | EG | EH | EI | EJ | EK | EL | |||
| 2 | 40 | 72.5 | 36 | 63.89 | 32 | 93.75 | 25 | 76 | 29 | 23 | 79.31 | 21 | 18 | 86 | 34 | 22 | 64.71 | 3 | 1 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 34 | 14 | 16 | 3 | 0 | 1 | 14 | 41 | 30 | 88 | 33 | 97 | 33 | 97 | 1 | 3 | 34 | 12 | 16 | 2 | 2 | 2 | 12 | 35 | 28 | 82 | 30 | 88 | 32 | 94 | 2 | 6 | |||||
test | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Upvote
0
Ok I can only input this much in here. To upload the whole data I would need to copy about 10 times, this is the first one
| test.xlsx | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | BI | BJ | BK | BL | BM | BN | BO | BP | BQ | BR | BS | BT | BU | BV | BW | BX | BY | BZ | CA | CB | CC | CD | CE | CF | CG | CH | CI | CJ | CK | CL | CM | CN | CO | CP | CQ | CR | CS | CT | CU | CV | CW | CX | CY | CZ | DA | DB | DC | DD | DE | DF | DG | DH | DI | DJ | DK | DL | DM | DN | DO | DP | DQ | DR | DS | DT | DU | DV | DW | DX | DY | DZ | EA | EB | EC | ED | EE | EF | EG | EH | EI | |||
| 2 | 40 | 72.5 | 36 | 63.89 | 32 | 93.75 | 25 | 76 | 29 | 23 | 79.31 | 21 | 18 | 86 | 34 | 22 | 64.71 | 3 | 1 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 34 | 14 | 16 | 3 | 0 | 1 | 14 | 41 | 30 | 88 | 33 | 97 | 33 | 97 | 1 | 3 | 34 | 12 | 16 | 2 | 2 | 2 | 12 | 35 | 28 | 82 | 30 | 88 | 32 | 94 | 2 | 6 | ||
| 3 | 51 | 49.02 | 55 | 40 | 45 | 51.11 | 35 | 65.71 | 54 | 30 | 55.56 | 45 | 28 | 62.22 | 42 | 15 | 35.71 | 3.2 | 1 | 4 | 4 | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 2 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 42 | 7 | 17 | 12 | 1 | 5 | 7 | 17 | 24 | 57 | 36 | 86 | 37 | 88 | 5 | 12 | 42 | 12 | 10 | 8 | 6 | 6 | 12 | 29 | 22 | 52 | 30 | 71 | 36 | 86 | 6 | 14 | ||
| 4 | 12 | 83.33 | 11 | 90.91 | 9 | 77.78 | 5 | 60 | 9 | 8 | 88.89 | 13 | 13 | 100 | 13 | 9 | 69.23 | 2.3 | 1 | 3 | 2 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 1 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 4 | 2 | 2 | 2 | 2 | 3 | 2 | 3 | 2 | 3 | 13 | 9 | 4 | 0 | 0 | 0 | 9 | 69 | 13 | 100 | 13 | 100 | 13 | 100 | 0 | 0 | 13 | 10 | 1 | 2 | 0 | 0 | 10 | 77 | 11 | 85 | 13 | 100 | 13 | 100 | 0 | 0 | ||
| 5 | 6 | 66.67 | 8 | 100 | 5 | 60 | 6 | 50 | 14 | 12 | 85.71 | 8 | 6 | 75 | 5 | 2 | 40 | 2.8 | 1 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 3 | 3 | 3 | 4 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 2 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 2 | 4 | 4 | 4 | 3 | 4 | 1 | 2 | 4 | 4 | 4 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 4 | 2 | 4 | 3 | 3 | 3 | 3 | 3 | 5 | 2 | 2 | 1 | 0 | 0 | 2 | 40 | 4 | 80 | 5 | 100 | 5 | 100 | 0 | 0 | 5 | 1 | 1 | 2 | 1 | 0 | 1 | 20 | 2 | 40 | 4 | 80 | 5 | 100 | 0 | 0 | ||
| 6 | 21 | 66.67 | 19 | 63.16 | 14 | 71.43 | 19 | 89.47 | 16 | 11 | 68.75 | 11 | 9 | 81.82 | 13 | 9 | 69.23 | 2.2 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 0 | 3 | 3 | 3 | 3 | 3 | 0 | 3 | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 13 | 3 | 7 | 3 | 0 | 0 | 3 | 23 | 10 | 77 | 13 | 100 | 13 | 100 | 0 | 0 | 13 | 3 | 4 | 6 | 0 | 0 | 3 | 23 | 7 | 54 | 13 | 100 | 13 | 100 | 0 | 0 | ||
| 7 | 17 | 58.82 | 58 | 46.55 | 53 | 43.4 | 38 | 57.89 | 49 | 23 | 46.94 | 51 | 34 | 66.67 | 48 | 18 | 37.5 | 2.6 | 1 | 4 | 4 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 4 | 4 | 4 | 3 | 4 | 3 | 3 | 3 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 3 | 3 | 4 | 3 | 4 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 48 | 26 | 11 | 9 | 1 | 1 | 26 | 54 | 37 | 77 | 46 | 96 | 47 | 98 | 1 | 2 | 48 | 15 | 12 | 10 | 10 | 1 | 15 | 31 | 27 | 56 | 37 | 77 | 47 | 98 | 1 | 2 | ||
| 8 | 34 | 47.06 | 30 | 33.33 | 28 | 50 | 29 | 37.93 | 31 | 12 | 38.71 | 40 | 17 | 42.5 | 31 | 7 | 22.6 | 2.5 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 3 | 4 | 3 | 3 | 4 | 4 | 3 | 4 | 3 | 3 | 3 | 4 | 4 | 3 | 2 | 2 | 2 | 4 | 3 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 3 | 4 | 3 | 4 | 3 | 3 | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 3 | 3 | 0 | 3 | 3 | 4 | 4 | 3 | 3 | 4 | 4 | 3 | 3 | 4 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 31 | 10 | 4 | 9 | 3 | 5 | 10 | 32 | 14 | 45 | 23 | 74 | 26 | 84 | 5 | 16 | 31 | 3 | 5 | 8 | 6 | 9 | 3 | 10 | 8 | 26 | 16 | 52 | 22 | 71 | 9 | 29 | ||
| 9 | 6 | 66.67 | 6 | 66.67 | 9 | 55.56 | 9 | 55.56 | 12 | 8 | 66.67 | 8 | 5 | 62.5 | 9 | 6 | 66.67 | 2.3 | 1 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 4 | 4 | 3 | 4 | 3 | 3 | 2 | 2 | 2 | 4 | 0 | 0 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 2 | 2 | 4 | 0 | 4 | 3 | 3 | 3 | 3 | 3 | 9 | 5 | 3 | 1 | 0 | 0 | 5 | 56 | 8 | 89 | 9 | 100 | 9 | 100 | 0 | 0 | 9 | 1 | 5 | 2 | 0 | 1 | 1 | 11 | 6 | 67 | 8 | 89 | 8 | 89 | 1 | 11 | ||
| 10 | 23 | 47.83 | 16 | 31.25 | 8 | 37.5 | 16 | 25 | 12 | 6 | 50 | 14 | 8 | 57.14 | 12 | 9 | 75 | 2.8 | 1 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 2 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 2 | 3 | 3 | 2 | 3 | 2 | 3 | 3 | 2 | 3 | 3 | 2 | 3 | 3 | 3 | 2 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 12 | 7 | 2 | 2 | 0 | 1 | 7 | 58 | 9 | 75 | 11 | 92 | 11 | 92 | 1 | 8 | 12 | 1 | 8 | 1 | 1 | 1 | 1 | 8 | 9 | 75 | 10 | 83 | 11 | 92 | 1 | 8 | ||
| 11 | 30 | 26.67 | 26 | 42.31 | 29 | 68.97 | 21 | 52.38 | 16 | 4 | 25 | 18 | 11 | 61.11 | 28 | 9 | 32.14 | 2.1 | 1 | 2 | 2 | 2 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 4 | 0 | 0 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | 28 | 11 | 10 | 2 | 3 | 2 | 11 | 39 | 21 | 75 | 23 | 82 | 26 | 93 | 2 | 7 | 28 | 3 | 12 | 5 | 5 | 3 | 3 | 11 | 15 | 54 | 20 | 71 | 25 | 89 | 3 | 11 | ||
| 12 | 26 | 34.62 | 18 | 38.89 | 15 | 60 | 19 | 31.58 | 15 | 7 | 46.67 | 18 | 9 | 50 | 19 | 7 | 36.84 | 2.4 | 1 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 2 | 2 | 3 | 2 | 3 | 3 | 3 | 4 | 2 | 4 | 2 | 2 | 2 | 2 | 2 | 3 | 4 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 2 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 1 | 4 | 3 | 3 | 2 | 4 | 3 | 0 | 2 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 19 | 9 | 1 | 4 | 3 | 2 | 9 | 47 | 10 | 53 | 14 | 74 | 17 | 89 | 2 | 11 | 19 | 2 | 5 | 4 | 3 | 5 | 2 | 11 | 7 | 37 | 11 | 58 | 14 | 74 | 5 | 26 | ||
| 13 | 13 | 61.54 | 16 | 81.25 | 15 | 53.33 | 16 | 68.75 | 15 | 7 | 46.67 | 16 | 10 | 62.5 | 18 | 6 | 33.33 | 2.2 | 1 | 3 | 4 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 3 | 3 | 3 | 4 | 3 | 2 | 3 | 3 | 2 | 3 | 3 | 2 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 2 | 2 | 3 | 2 | 3 | 3 | 3 | 1 | 3 | 0 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 2 | 3 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 18 | 5 | 6 | 6 | 1 | 0 | 5 | 28 | 11 | 61 | 17 | 94 | 18 | 100 | 0 | 0 | 18 | 4 | 7 | 2 | 4 | 1 | 4 | 22 | 11 | 61 | 13 | 72 | 17 | 94 | 1 | 6 | ||
| 14 | 19 | 42.11 | 12 | 50 | 17 | 64.71 | 18 | 61.11 | 12 | 17 | 58.33 | 14 | 7 | 50 | 16 | 8 | 50 | 2.4 | 1 | 3 | 3 | 3 | 4 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 16 | 0 | 6 | 8 | 2 | 0 | 0 | 0 | 6 | 38 | 14 | 88 | 16 | 100 | 0 | 0 | 16 | 7 | 5 | 2 | 2 | 0 | 7 | 44 | 12 | 75 | 14 | 88 | 16 | 100 | 0 | 0 | ||
| 15 | 29 | 37.93 | 36 | 25 | 25 | 56 | 33 | 30.3 | 39 | 15 | 38.46 | 40 | 21 | 52.5 | 44 | 6 | 13.64 | 2.4 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 2 | 3 | 2 | 3 | 4 | 4 | 3 | 2 | 3 | 2 | 3 | 4 | 4 | 0 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 44 | 7 | 22 | 11 | 3 | 1 | 7 | 16 | 29 | 66 | 40 | 91 | 43 | 98 | 1 | 2 | 44 | 10 | 13 | 8 | 7 | 6 | 10 | 23 | 23 | 52 | 31 | 70 | 38 | 86 | 6 | 14 | ||
| 16 | 4 | 50 | 3 | 66.67 | 3 | 33.33 | 4 | 50 | 5 | 0 | 0 | 2 | 1 | 50 | 5 | 0 | 0 | 1.6 | 1 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 2 | 2 | 2 | 1 | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 3 | 1 | 1 | 2 | 2 | 1 | 3 | 2 | 2 | 2 | 3 | 2 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 2 | 3 | 1 | 2 | 2 | 2 | 3 | 1 | 3 | 3 | 2 | 2 | 3 | 0 | 0 | 2 | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 3 | 2 | 3 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 5 | 0 | 1 | 1 | 3 | 0 | 0 | 0 | 1 | 20 | 2 | 40 | 5 | 100 | 0 | 0 | 5 | 0 | 3 | 0 | 1 | 1 | 0 | 0 | 3 | 60 | 3 | 60 | 4 | 80 | 1 | 20 | ||
| 17 | 11 | 72.73 | 9 | 66.67 | 13 | 61.54 | 8 | 25 | 14 | 7 | 50 | 8 | 6 | 75 | 12 | 4 | 33.33 | 2.1 | 1 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 2 | 4 | 2 | 3 | 3 | 3 | 3 | 4 | 0 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | 12 | 3 | 5 | 3 | 1 | 0 | 3 | 25 | 8 | 67 | 11 | 92 | 12 | 100 | 0 | 0 | 12 | 2 | 6 | 3 | 1 | 0 | 2 | 17 | 8 | 67 | 11 | 92 | 12 | 100 | 0 | 0 | ||
test | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Upvote
0
Hello. So I don't know why but I seem to be able to do the correlation in Mac but not my Windows. Odd. But perhaps I missed something when previously trying to do in Windows.
Upvote
0
Similar threads
- Solved
- Question
