14. Emelia is very concerned about safety and has conducted a study to determine how many bike helmets were replaced at each loc
ation last year. She wants to include the survey results in this spreadsheet. Switch to the Helmets Per Location worksheet. Open the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook, and then switch back to Helmets Per Location worksheet. Link the data to the Helmets Per Location worksheet as described below: a. In cell C3 of the Helmets Per Location worksheet, create a formula without using a function that contains a relative reference to cell D2 of the 2019 Damaged Helmet Survey worksheet in the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook. b. In the Helmets Per Location worksheet, copy the formula in cell C3 to the range C4:C5 without copying the formatting. c. Close the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook and switch back to the Helmets Per Location worksheet.
2 answers:
Answer:
Explanation:
Known Variables A = max Daily Rentals
X = Damaged helmets %
lets find the formula to calculate Helmets per location :taking 1st row as an example.
412 = B - (B*13/100)
412 = (100B-13B)/100
412*100 = 87B
B= 412*100/87
Hence, the generic formula becomes : B= A*100/(100-X)
Applying the same formula for each row and then using ROUND function of excel to round off the digits
=ROUND(number,digits) where number is the number you would like to round off and the digits is the number of decimal digits for it to round off. Since we want natural numbers in our example, we will be using digits as 0.
Explanation:
See attached pictures also.
You might be interested in
<h2>Answer:</h2><h2></h2>
//import the Random and Scanner classes
import java.util.Random;
import java.util.Scanner;
//Begin class definition
public class ChangeUp {
//Begin the main method
public static void main(String args[]) {
//Initialize the empty array of 6 elements
int [] numbers = new int [6];
//Call to the populateArray method
populateArray(numbers);
} //End of main method
//Method to populate the array and print out the populated array
//Parameter arr is the array to be populated
public static void populateArray(int [] arr){
//Create object of the Random class to generate the random index
Random rand = new Random();
//Create object of the Scanner class to read user's inputs
Scanner input = new Scanner(System.in);
//Initialize a counter variable to control the while loop
int i = 0;
//Begin the while loop. This loop runs as many times as the number of elements in the array - 6 in this case.
while(i < arr.length){
//generate random number using the Random object (rand) created above, and store in an int variable (randomNumber)
int randomNumber = rand.nextInt(6);
//(Optional) Print out a line for formatting purposes
System.out.println();
//prompt user to enter a value
System.out.println("Enter a value " + (i + 1));
//Receive the user input using the Scanner object(input) created earlier.
//Store input in an int variable (inputNumber)
int inputNumber = input.nextInt();
//Store the value entered by the user in the array at the index specified by the random number
arr[randomNumber] = inputNumber;
//increment the counter by 1
i++;
}
//(Optional) Print out a line for formatting purposes
System.out.println();
//(Optional) Print out a description text
System.out.println("The populated array is : ");
//Print out the array content using enhanced for loop
//separating each element by a space
for(int x: arr){
System.out.print(x + " ");
}
} //End of populateArray method
} //End of class definition
<h2>Explanation:</h2>
The code above is written in Java. It contains comments explaining the lines of the code.
This source code together with a sample output has been attached to this response.
<span class="sg-text sg-text--link sg-text--bold sg-text--link-disabled sg-text--blue-dark">
java
</span>