MATLAB: Reverse calculate a table of values

calculationsreverseinterpolationtable

Hi,

I'm looking for a way to determine the Y axis from a given Z value in a 3D table. Basically reverse interpolate the table.

Is there a way to determine it?

X/Y 0 100 175 250 325 400 475 575

60 0 5 13 21 29 40 51 68

80 0 7 16 24 32 40 49 63

90 0 7 16 25 34 42 49 61

100 0 6 15 25 33 41 49 59

110 0 6 15 23 32 40 48 58

120 0 5 14 22 30 38 47 57

130 0 5 13 21 29 37 45 56

140 0 5 13 21 29 37 44 55

150 0 4 12 21 29 37 44 54

160 0 3 12 20 29 37 44 53

Say, Z = 45, X = 125, Y = ?

Thanks in advance!

Best Answer

I am not certain what a ‘3D table’ is. Perhaps you intend a three column table or array.

If that is true, then the interp1 function could be appropriate.

The code for that, assuming ‘Y’ and ‘Z’ are vectors, would be:

Yi - interp1(Z, Y, Zi);

and ‘Zi’ is the scalar or vector you want to find the ‘Yi’ values for.

Related Solutions

MATLAB: Create matrix with periodic increments

The function bsxfun is really handy for these kind of tasks:

>> X = [1;2;3;4;5;6];
>> Y = bsxfun(@plus,X,0:10:40);
>> Z = bsxfun(@plus,Y(:),0:20);
>> Z
Z =
    1    2    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17   18   19   20   21
    2    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17   18   19   20   21   22
    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17   18   19   20   21   22   23
    4    5    6    7    8    9   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24
    5    6    7    8    9   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25
    6    7    8    9   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26
   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31
   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31   32
   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31   32   33
   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31   32   33   34
   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31   32   33   34   35
   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31   32   33   34   35   36
   21   22   23   24   25   26   27   28   29   30   31   32   33   34   35   36   37   38   39   40   41
   22   23   24   25   26   27   28   29   30   31   32   33   34   35   36   37   38   39   40   41   42
   23   24   25   26   27   28   29   30   31   32   33   34   35   36   37   38   39   40   41   42   43
   24   25   26   27   28   29   30   31   32   33   34   35   36   37   38   39   40   41   42   43   44
   25   26   27   28   29   30   31   32   33   34   35   36   37   38   39   40   41   42   43   44   45
   26   27   28   29   30   31   32   33   34   35   36   37   38   39   40   41   42   43   44   45   46
   31   32   33   34   35   36   37   38   39   40   41   42   43   44   45   46   47   48   49   50   51
   32   33   34   35   36   37   38   39   40   41   42   43   44   45   46   47   48   49   50   51   52
   33   34   35   36   37   38   39   40   41   42   43   44   45   46   47   48   49   50   51   52   53
   34   35   36   37   38   39   40   41   42   43   44   45   46   47   48   49   50   51   52   53   54
   35   36   37   38   39   40   41   42   43   44   45   46   47   48   49   50   51   52   53   54   55
   36   37   38   39   40   41   42   43   44   45   46   47   48   49   50   51   52   53   54   55   56
   41   42   43   44   45   46   47   48   49   50   51   52   53   54   55   56   57   58   59   60   61
   42   43   44   45   46   47   48   49   50   51   52   53   54   55   56   57   58   59   60   61   62
   43   44   45   46   47   48   49   50   51   52   53   54   55   56   57   58   59   60   61   62   63
   44   45   46   47   48   49   50   51   52   53   54   55   56   57   58   59   60   61   62   63   64
   45   46   47   48   49   50   51   52   53   54   55   56   57   58   59   60   61   62   63   64   65
   46   47   48   49   50   51   52   53   54   55   56   57   58   59   60   61   62   63   64   65   66

MATLAB: What proportion of students failed the course (i.e., got a mark of less than 50)

I get 63, not 64:

x = [83 58 60 66 73 71 89 77 67 48 54 51 64 69 71 75 52 76 63 88 63 78 66 75 95 32 79 34 72 54 65 75 59 55 62 58 47 65 87 49 91 86 64 100 46 69 57 85 65 63 59 100 55 70 43 45 69 85 75 69 73 74 75 67 68 79 62 54 84 59 65 86 56 52 61 85 64 50 64 50 71 77 66 46 78 73 59 87 53 69 53 62 73 37 70 54 51 80 43 67 65 74 100 86 68 59 83 45 62 57 84 51 48 84 85 92 65 65 42 63 68 83 90 67 68 81 77 86 100 84 76 67 60 51 66 64 76 88 37 58 49 58 86 72 71 66 79 76 46 54 72 59 79 64 81 65 69 41 94 51 53 75 52 71 85 69 46 57 82 70 97 64 52 56 40 65 65 59 69 59 70 74 94 63 83 66 82 80 75 55 47 73 58 55 67 84 77 58 73 58 65 94 67 44 59 58 58 54 62 61 77 97 52 67 79 76 75 67 50 76 85 90 76 86 76 68 72 90 38 52 49 74 62 59 69 51 83 64 98 100 86 50 70 71 86 50 85 94 86 53 74 55 74 77 66 71 58 76 70 77 60 78 70 71 56 91 73 57 53 75 57 93 66 64 52 88 54 68 78 57 90 85 71 97 59 73 68 100 59 73 69 79 58 99 69 64 71 77 59 55 61 62 62 68 80 82 80 88 90 80 52 30 78 57 80 70 54 73 100 82 73 63 83 63 88 62 37 70 72 85 58 64 59 43 59 91 72 68 93 46 51 94 62 67 66 75 65 92 88 73 67 51 91 65 61 68 60 75 57 66 63 90 56 42 53 78 84 74 55 78 92 78 73 64 92 81 90 77 48 84 72 64 74 58 49 85 76 69 63 59 69 61 58 69 64 72 62 79 60 59 66 57 81 81 75 73 82 63 97 54 54 66 79 84 64 84 59 64 62 62 83 82 65 77 60 82 74 56 64 73 98 83 51 81 56 60 85 52 79 70 84 65 31 80 69 54 50 61 53 83 64 100 38 68 90 89 72 51 100 96 63 41 63 63 72 75 59 62 65 55 56 84 62 55 61 79 53 86 54 51 73 80 50 75 56 75 39 75 68 68 70 79 78 64 93 56 75 95 89 65 65 66 76 40 71 68 68 67 88 65 71 70 65 70 52 55 81 74 41 91 76 51 100 54 47 70 58 49 75 71 49 82 87 96 82 81 53 57 67 53 94 67 50 64 75 68 97 74 68 63 61 59 65 80 47 63 77 85 80 53 48 96 62 57 86 76 80 74 57 80 70 69 75 80 67 73 66 48 90 73 72 74 66 56 63 70 76 57 70 67 78 77 64 67 75 62 72 76 78 69 74 61 64 63 96 76 51 81 49 93 66 66 71 67 62 62 77 90 85 72 66 75 75 77 65 60 54 78 100 97 82 52 65 97 74 93 100 87 65 74 54 63 79 64 50 73 74 45 71 77 86 81 68 35 57 90 70 79 67 91 70 85 92 61 82 80 92 73 62 83 61 60 61 92 34 80 77 43 70 83 91 73 60 63 81 67 55 76 72 90 53 59 77 74 65 78 85 63 80 99 84 61 86 79 72 78 54 85 68 97 66 67 80 77 68 56 72 74 71 81 61 45 88 62 74 84 40 78 57 69 63 75 71 66 82 70 92 58 71 52 82 97 89 65 74 63 79 64 90 61 55 52 67 80 82 49 77 76 57 51 88 61 65 70 75 66 62 100 75 71 80 53 60 73 98 54 76 92 100 68 76 72 55 93 66 89 54 62 85 62 68 72 63 88 53 58 69 51 82 84 70 77 69 64 94 70 47 95 60 69 60 62 67 94 56 69 77 78 64 97 58 64 58 67 78 54 62 88 75 58 52 69 80 69 89 64 80 67 76 74 40 59 92 68 84 46 30 75 66 73 55 57 79 72 62 58 65 75 82 82 75 74 73 59 59 98 100 71 60 77 44 64 96 69 59 44 74 58 97 71 69 68 60 67 74 83 90 81 73 77 53 79 75 69 88 75 89 71 71 100 83 67 74 42 52 56 75 76 61 76 69 83 50 63 78 96 43 67 60 47 82 82 76 69 54 67 43 100 68 63 83 96 66 76 72 79 54 66 68 83 63 36 46 82 56 53 77 58 83 59 73 100 78 60 64 85 70 76 64 81 83 63 65 83 66 80 65 83 99 66 56]'
failCount = sum(x < 50)
failRatio = failCount / numel(x)

I see

failCount =
    63
failRatio =
        0.0648815653964985

Best Answer

Related Solutions

MATLAB: Create matrix with periodic increments

MATLAB: What proportion of students failed the course (i.e., got a mark of less than 50)

Related Question