Microsoft Excel Question:
Download Questions PDF

I have some problems in regression of my data, i am pleasured to solve my problem and create new regression in these data.
x=(1267.4 - 1267.5 - 1267.6 - 1267.7 - 1267.8 - 1267.9 - 1268.0 - 1268.1 - 1268.2 - 1268.3 - 1268.4 - 1268.5 - 1268.6 - 1268.7 - 1268.8 - 1268.9 - 1269.0 - 1269.1 - 1269.2 - 1269.3 - 1269.4 - 1269.5 - 1269.6 - 1269.7 - 1269.8 - 1269.9 - 1270.0 - 1270.1 - 1270.2 - 1270.3 - 1270.4 - 1270.5 - 1270.6 - 1270.7 - 1270.8 - 1270.9 - 1271.0 - 1271.1 - 1271.2 - 1271.2 - 1271.3 - 1271.4 - 1271.5 - 1271.6 - 1271.7 - 1271.8 - 1271.9 - 1272.0 - 1272.1 - 1272.2 - 1272.3 - 1272.4 - 1272.5 - 1272.6 - 1272.7 - 1272.8 - 1272.9 - 1273.0 - 1273.1 - 1273.2 - 1273.3 - 1273.4 - 1273.5 - 1273.6 - 1273.7 - 1273.8 - 1273.9 - 1274.0 - 1274.1 - 1274.2 - 1274.3 - 1274.4 - 1274.5 - 1274.6 - 1274.7 - 1274.8 - 1274.9 - 1275.0 - 1275.1 - 1275.2 - 1275.3 - 1275.4 - 1275.5 - 1275.6 - 1275.7 - 1275.8 - 1275.9 - 1276.0 - 1276.1 - 1276.2 - 1276.3 - 1276.4 - 1276.5 - 1276.6 - 1276.7 - 1276.8 - 1276.9 - 1277.0 - 1277.1 - 1277.2 - 1277.3 - 1277.4 - 1277.5 - 1277.6 - 1277.7 - 1277.8 - 1277.9 - 1278.0)
y=(0.01 - 0.02 - 0.03 - 0.04 - 0.06 - 0.08 - 0.10 - 0.13 - 0.16 - 0.19 - 0.24 - 0.29 - 0.34 - 0.40 - 0.46 - 0.52 - 0.59 - 0.66 - 0.73 - 0.81 - 0.90 - 0.98 - 1.07 - 1.16 - 1.26 - 1.36 - 1.48 - 1.62 - 1.77 - 1.94 - 2.13 - 2.32 - 2.53 - 2.74 - 2.97 - 3.21 - 3.46 - 3.73 - 4.00 - 4.28 - 4.56 - 4.86 - 5.16 - 5.46 - 5.78 - 6.10 - 6.42 - 6.76 - 7.10 - 7.45 - 7.81 - 8.17 - 8.54 - 8.91 - 9.28 - 9.66 - 10.05 - 10.44 - 10.84 - 11.24 - 11.64 - 12.05 - 12.46 - 12.88 - 13.30 - 13.72 - 14.14 - 14.58 - 15.01 - 15.45 - 15.90 - 16.34 - 16.79 - 17.24 - 17.70 - 18.16 - 18.62 - 19.09 - 19.56 - 20.04 - 20.53 - 21.01 - 21.50 - 21.99 - 22.49 - 22.99 - 23.50 - 24.01 - 24.53 - 25.05 - 25.57 - 26.09 - 26.62 - 27.16 - 27.69 - 28.23 - 28.78 - 29.33 - 29.90 - 30.47 - 31.04 - 31.61 - 32.18 - 32.75 - 33.32 - 33.90 - 34.47 )

Answer:


No Answer is Posted For this Question
Be the First to Post Your Answer Now

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
Best regards,
i have some problems in regression of my data, i am pleasured to solve my problem and create new regression in these data.
x y
1267.4 0.01
1267.5 0.02
1267.6 0.03
1267.7 0.04
1267.8 0.06
1267.9 0.08
1268.0 0.10
1268.1 0.13
1268.2 0.16
1268.3 0.19
1268.4 0.24
1268.5 0.29
1268.6 0.34
1268.7 0.40
1268.8 0.46
1268.9 0.52
1269.0 0.59
1269.1 0.66
1269.2 0.73
1269.3 0.81
1269.4 0.90
1269.5 0.98
1269.6 1.07
1269.7 1.16
1269.8 1.26
1269.9 1.36
1270.0 1.48
1270.1 1.62
1270.2 1.77
1270.3 1.94
1270.4 2.13
1270.5 2.32
1270.6 2.53
1270.7 2.74
1270.8 2.97
1270.9 3.21
1271.0 3.46
1271.1 3.73
1271.2 4.00
1271.3 4.28
1271.4 4.56
1271.5 4.86
1271.6 5.16
1271.7 5.46
1271.8 5.78
1271.9 6.10
1272.0 6.42
1272.1 6.76
1272.2 7.10
1272.3 7.45
1272.4 7.81
1272.5 8.17
1272.6 8.54
1272.7 8.91
1272.8 9.28
1272.9 9.66
1273.0 10.05
1273.1 10.44
1273.2 10.84
1273.3 11.24
1273.4 11.64
1273.5 12.05
1273.6 12.46
1273.7 12.88
1273.8 13.30
1273.9 13.72
1274.0 14.14
1274.1 14.58
1274.2 15.01
1274.3 15.45
1274.4 15.90
1274.5 16.34
1274.6 16.79
1274.7 17.24
1274.8 17.70
1274.9 18.16
1275.0 18.62
1275.1 19.09
1275.2 19.56
1275.3 20.04
1275.4 20.53
1275.5 21.01
1275.6 21.50
1275.7 21.99
1275.8 22.49
1275.9 22.99
1276.0 23.50
1276.1 24.01
1276.2 24.53
1276.3 25.05
1276.4 25.57
1276.5 26.09
1276.6 26.62
1276.7 27.16
1276.8 27.69
1276.9 28.23
1277.0 28.78
1277.1 29.33
1277.2 29.90
1277.3 30.47
1277.4 31.04
1277.5 31.61
1277.6 32.18
1277.7 32.75
1277.8 33.32
1277.9 33.90
1278.0 34.47
Is there a way in excel to write a formula to mark a cell with a symbol or letter or number that is the inverse of coordinates marked. example: if i mark the coordinates c/p with a "1" then excel will automatically mark its inverse p/c. and if i erase a symbol from, lets say, d/g, then excel removes a symbol from the inverse which would be g/d. i will need to mark any particular (several, many) particular cells more than once such as 2 or three times. can i do it all with the same symbol or number (or letter).

reason: i want to make a table of sorts where the names of badminton players are listed
down vertically and in the same order horizontally. therefore b,b would have the same name such as carol, c/c might be joe, d,d might be shaun, etc.
that way when, lets say carol and shaun are partners in a game and i type the symbol in the coordinates b/d, then excel will mark d/b automatically. that way i can keep track by seeing who has played with who already, not at all, or even played together 2 or 3 times. does this make sense to you? (i doubt i mathmatically did not write coordinates properly, maybe it should be a letter then comma then the other letter).