Computers and Technology

Can someone help me write a code for this set of direction. 100 POINTS. Please dont copy the answer from online and post it here its wrong.In the main: Declare and create two arrays called nums1 and nums2 to eventually store 15 integers each.Declare a third array called nums3 and assign to it 15 values of your choice (from 1 to 30 BUT NOT in sorted order), for example {25,12,6,2,30}Write a method called initArray to initialize an array of int to values from 0 to 14 using a loop. ( write a method that called initArray to assign an array integers 0 to 14 using a loop.Write a method called displayArray to display all numbers in an array of int on one line using this format: 0 1 2 3 4 and so on. Back in the main: Write the code that calls the initArray method passing in nums1 Write the code that calls the displayArray method first passing in nums1, then passing in nums3. Display an appropriate message before calling the display array so that your results look like this: The nums1 array after initializing: 0 1 2 3 4 and so on The nums3 array after initializing: 25 12 6 2 30 and so on5. Write a method called genRandom which takes the array nums2 as a parameter and fills it with random numbers between 1 and 100.in a for loop, Back in the main:Add a call to the genRandom methods passing in nums2 after providing an appropriate message explaining what the output will be. Your output should looks like this: The nums2 array after initializing: 17 4 12 (random numbers different each time) and so onWrite a method called sumRandom which will take an array as a parameter. It sums all numbers in the array and returns the sum as the value of the method.Back in the main: Add a call to the sumRandom method passing it nums2, then display a message telling what the output is followed by the results. (REMEMBER: when a method returns a value, you need to supply a variable to receive the answer in the calling statement.Write a method called underForty which takes an array as a parameter. It sums all numbers that have a value less than 40 in the array and returns the sum as the value of the method.Back in the main: Add a call to the underForty method passing it nums2, then displays a message telling what the output is followed by the results Write a method called smallest which takes an array as a parameter. It finds the smallest of the number in the array and returns it as the value of the method.Back in the main: This will seem redundant to what you did earlier, but First call the displayArray method so your output looks like this: The nums3 array after initializing:10 5 15 (these should be the numbers you assigned in the create and initialize declaration) and so on. Now, add a call to the smallest method passing it nums3, then display a message telling what the output is followed by the resultsWrite a method called largest which takes an array as a parameter. It finds the largest of the numbers in the array and returns its index as the value of the method.Back in the main: Call the largest method passing nums3, then display a message telling what the output is followed by the results.Write a method called search which takes an array as a parameter and a random number you want to search for. (just pick one out of your array and pass it in as the second parameter) It finds the FIRST instance of that number and returns its index as the value of the method. If it does not find your random number, it returns a -1In the main: call the search method passing it nums3, then display a message telling what the output is followed by the results Use a conditional to display either of these statements: For example: The random number 6 was found at location 2 OR The random number 6 was NOT foundWrite a method called addToOverThirty which takes an array as a parameter. It adds 1 to all numbers that have a value greater than 30 in the array. (hmmm!, can you figure out why I said hmmm? Write the method anyways)Back in the main:Add a call to the addToOverThirty method passing it nums3, then display a message telling what the output is followed by the results For example: The nums3 array after adding 1 to all numbers greater than 30 is 10 6 15 and so on (check with the values you assigned to nums3)
Please help complete Excel (screenshot below) by using the steps below. Ty!Start Excel. Download and open the file named EXP19_Excel_Ch08_HOEAssessment_RobertsFlooring.xlsx. Grader has automatically added your last name to the beginning of the filename.You would like to use the Data Analysis ToolPak to create a histogram to visualize the data. To complete this task, first ensure the Data Analysis ToolPak is active. Next, use the histogram feature in the Data Analysis ToolPak to place a histogram in the worksheet. Use the range C3:C13 as the Input Range. Use the range F3:F10 as the Bin range. Place the output in cell F13. Be sure to check Labels, Cumulative Percentage, and Chart Output. Position the Chart Output so that the upper left corner starts just inside the borders of cell F23.You would like to add a linear trendline to a scatter plot to help better forecast pricing based on square footage of the installation space. You will position the chart to start in cell K3, place the sqft data in the X axis, the Cost data in the Y axis, and add a trendline with equation and R-square. Be sure to add a descriptive chart title (Price Forecast).You would like to use the FORECAST.LINEAR function to calculate a cost estimate to install 1500 sqft of flooring. Be sure to use the cost data as the known_ys and the Sqft data as the known_xs. Place the formula in cell I4.Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side.Save and close EXP_Excel_CH08_HOEAssessment_RobertsFlooring.xlsx. Exit Excel. Submit the file as directed.