Purchase Solution

Array sorting and finding values in Visual Basic

Not what you're looking for?

Ask Custom Question

See the attached file.
I have a multi-dimensional array that needs to have the following questions answered each by a separate button and sub or function procedure.

The array is
Dim Kidsinsports(10,3) " schools + sports" e.g. School 1 has 10 kids in football, 10 in basketball and 10 in volleyball. Sports are organized by (Football, Basketball, Volleyball)

Dim costofsports(3,10) = equals to home much each individual school spent for Basketball, footbal, volleyball

Dim kidsinsports(,) As Integer = {{10, 10, 10}, {20, 10, 15}, {10, 5, 10}, {20, 20, 20}, {11, 10, 12}, {22, 10, 10}, {5, 0, 5}, {10, 12, 23}, {15, 3, 9}, {12, 17, 24}}

Dim costofsports(,) As Double = {{100, 200, 150, 120, 231, 102, 87, 145, 156, 130}, {100, 56, 78, 99, 105, 180, 230, 165, 134, 75}, {110, 120, 130, 140, 77, 120, 150, 150, 190, 200}}

1. Which school spent the most money on football
2. Which sport the last school spent the most money on
3. Which school had the most kids playing basketball
4. Which sport the third school had the most students participating
5. Total amount spent by call schools on volleyball
6. Total number of students who played any sport
7. Which school has the most students participating in sports
8. Which was the most popular sport in terms of money spent
9. Which was the most popular sport in terms of student participation
10. Total number of students playing basketball.

Attachments
Purchase this Solution
Solution Summary

The solution provides sample codes of sorting array in Bisual Basic.

Purchase this Solution
Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Javscript Basics

Quiz on basics of javascript programming language.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

View More Free Quizzes
Related BrainMass Solutions

  • Find the Largest and Smallest and Sort values in array C++

    60920 Find the Largest and Smallest and Sort all the values in an Array in ascending order Write two function in C++ with using arrays to find largest and smallest number. For example you have 1,43,42,9,8,5.

  • C/C++ Console Program that Uses Arrays

    The array is stored in the array variable arr and the size of this array is stored in the variable n. After reading the values, sorting is done.

  • C++ Sort and Search Evaluation

    This work has been done in Microsoft Visual Studio. Good luck and thanks for using Brainmass.com! C++ sort and search evaluations are examined.

  • Arrays

    You can think of a two-dimensional array as a matrix, or grid, with width and height or rows and columns. Sorting Arrays ========== Sorting related data stored in an array is often useful.

  • VB.NET GUI program that reads file data files display, sort

    317071 Create a Visual Basic.NET GUI program that allows users to ingest Mission Title and Adjusted Total Box Office Profit data from text files into two 1D arrays. I need assistance with a Visual Basic form.

  • Creating a sorting array

    Add the attached file, build and run. Good Luck! The expert creates a sorting array. Adjacent pairs of elements in an array are determined. The solution is provided in a Java file.

  • Data structures comparison

    Then add the two pieces two a new, a larger array with the new value in the right spot. This is very expensive from a memory standpoint. A binary tree is very fast to traverse and especially for finding single valyues.

  • Sorting a List and Displaying Mean

    (see diagram in attached file) The document "Array Process.doc" in the attached compressed file, contains the pseducode for finding the mean salary as well as the number of salaries above and below the mean taking as input the salary[1..N] array.

  • Structured Data Type - Array

    Like search algorithms, sort algorithms require logical thinking and "looping" skills. Array sorting techniques require much of the same thinking skills as searching. The most important aspect by far is simply knowing how to manipulate an array.

View More Related Solutions