You have been tasked with examining data from your regional Scout packs.  The data file that is in Isidore has the following data: 1.       Scout Name 2.       Scout Den 3.       Badge Earned 4.       Date Earned 1.       Read the data in the file (of arbitrary length) to an array (10 Points) a.       Use a file dialog to retrieve the data file 2.       Create a record for each scout in the pack with the following information  (25 Points) a.       Scout Name b.      Scout Den c.       Badges Earned (no more than 300 can be earned) d.      Date Earned 3.       Output to an Excel Sheet with a column for each scout the  (25 Points) a.       badges earned by each scout b.      The header of each column will be the Scout’s name 4.       Output file  (30 Points) a.       Has the following information i.      Number of scout in the pack ii.      The total number of awards earned iii.      The average number of awards earned per scout iv.      The standard deviation of award earned v.      The probability of earning 10 awards b.      Use a file dialog to ask for the file name for output 5.       The input and output sections should check for file name errors. (10 Points)

Introduction:

In this assignment, we will be examining data from regional Scout packs. The data file provided in Isidore contains information about each scout, including their name, den, badge earned, and the date it was earned. Our task is to perform several operations on this data, including reading it from the file, creating records for each scout, outputting the data to an Excel sheet, generating an output file with statistics, and performing error checks for file names.

Data Reading and Array Creation:

The first step is to read the data from the file and store it in an array. We can achieve this by using a file dialog to allow the user to select the data file. Once the file is selected, we will read its contents and store them in the array. Since the length of the data file is arbitrary, we need to account for varying file sizes.

Creating Records for Each Scout:

After reading the data file and storing it in an array, we need to create a record for each scout in the pack. Each record should contain the scout’s name, den, badges earned, and the date each badge was earned. It is important to note that a scout can earn up to 300 badges.

Outputting to an Excel Sheet:

The next step is to output the data to an Excel sheet. For each scout, there should be a column that displays the badges earned by that scout. The header of each column will be the scout’s name. This will allow us to easily analyze the data and perform further calculations.

Output File and Statistics:

Once the data is properly organized in the Excel sheet, we need to generate an output file that includes various statistics. The output file should contain the following information:

– The number of scouts in the pack.
– The total number of awards earned by all scouts.
– The average number of awards earned per scout.
– The standard deviation of awards earned.
– The probability of earning 10 awards.

To achieve this, we will use a file dialog to ask the user for the output file name. The program will calculate the required statistics based on the data and write them to the output file.

File Name Error Checks:

Finally, we need to implement error checks for file names. This means ensuring that the input and output file names are valid and that the program can successfully access and modify them. Error handling is crucial to ensure smooth execution of the program and prevent any unexpected issues.

In summary, this assignment involves reading data from a file, creating records for each scout, outputting the data to an Excel sheet, generating an output file with statistics, and performing error checks for file names. These operations will provide valuable insights into the Scout packs’ data and contribute to a comprehensive analysis.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer