quachchan
08-10-2009, 10:45 PM
mình có một bài tập như sau: dùng Excel để thực hiện chuyển vị từ một ma trận có sẵn, rồi phép nhân hai ma trận. Ai biết chỉ dùm mình có hình minh họa càng tốt. Thanks trước nha!
View Full Version : ai giúp mình bài tập với Excel với
ngoisaocodon
09-05-2009, 12:04 AM
1>
Step 1 Open Microsoft Excel from your computer. This may be in your Start menu. Microsoft Excel is usually located in your Microsoft Office folder.
Step 2 Click on a new document, or open an old one. You will draw the information you need to transpose a data array from here.
Step 3 Select a range of data with a similar size to the size of the range containing the data, but with rows and columns reversed. In this example, we will call the rows and columns you need A1 through B4.
Step 4 Type the following formula in the formula box: “=Transpose(A1:B4).” This formula creates a transposed link to cells A1:B4 in your Excel document.
Step 5 Select the range A5:A7 starting with the formula cell. Press F2 and then press Ctrl+Shift+Enter. If the formula is not entered correctly (as an array formula) the single result will be 1.
Step 6 Hit “Enter,” and you will see the transposed data appear in the selected cells. If you don’t see this right away, wait a second to make sure Excel is functioning properly. Try it again if necessary.
2>
If Array1 is A1:B2
Array2 is D1:E2
Highlight a 2x2 blank area
In the formula bar type in =MMULT(A1:B2,D1:E2)
Then this is the important part: instead of enter, use ctrl+shift+enter. The formula will be entered as an multi-cell array formula and it will look like this
{=MMULT(A1:B2,D1:E2)}
You can't manually type in the braces. You have to use the ctrl+shift+enter method.
Hope that helps.
Step 1 Open Microsoft Excel from your computer. This may be in your Start menu. Microsoft Excel is usually located in your Microsoft Office folder.
Step 2 Click on a new document, or open an old one. You will draw the information you need to transpose a data array from here.
Step 3 Select a range of data with a similar size to the size of the range containing the data, but with rows and columns reversed. In this example, we will call the rows and columns you need A1 through B4.
Step 4 Type the following formula in the formula box: “=Transpose(A1:B4).” This formula creates a transposed link to cells A1:B4 in your Excel document.
Step 5 Select the range A5:A7 starting with the formula cell. Press F2 and then press Ctrl+Shift+Enter. If the formula is not entered correctly (as an array formula) the single result will be 1.
Step 6 Hit “Enter,” and you will see the transposed data appear in the selected cells. If you don’t see this right away, wait a second to make sure Excel is functioning properly. Try it again if necessary.
2>
If Array1 is A1:B2
Array2 is D1:E2
Highlight a 2x2 blank area
In the formula bar type in =MMULT(A1:B2,D1:E2)
Then this is the important part: instead of enter, use ctrl+shift+enter. The formula will be entered as an multi-cell array formula and it will look like this
{=MMULT(A1:B2,D1:E2)}
You can't manually type in the braces. You have to use the ctrl+shift+enter method.
Hope that helps.
