Use Excel to develop a regression model for the Consumer Food Database (using the "Excel Databases.xls" file on Blackboard) to p
redict Annual Food Spending by Annual Household Income for those living in the Metro area only. Suppose a household in the metro area has an annual income of $60,000. Predict how much they spend on food per year. Write your answer as a number (do not include the $ sign or comma) and round to 2 decimal places.
1 answer:
Answer:
Step 1 : Create an Indicator Variable for metro cities using formula mentioned in formula bar.
Step 2: Filter the Data on Metro cities i.e. select only those cities with Metro Indicator 1.
Step 3: Paste this filtered data to a new sheet.
Step 4: Go to Data - Data Analysis - Regression
Step 5: Enter the range of Y-variable and X-variable as shown. Select Output range and click on residuals. It will give you Output Summary and the Predicted Values along with Residuals
Please see attachment
You might be interested in
Solution :
class Employee:
#Define the
#constructor.
def ____(
, ID_number,
, email):
#Set the values of
#the data members of the class.
= name
_number = ID_number
= salary
self.email_address = email
#Define the function
#make_employee_dict().
def make_employee_dict(list_names, list_ID, list_salary, list_email):
#Define the dictionary
#to store the results.
employee_dict = {}
#Store the length
#of the list.
list_len = len(list_ID)
#Run the loop to
#traverse the list.
for i in range(list_len):
#Access the lists to
#get the required details.
name = list_names[i]
id_num = list_ID[i]
salary = list_salary[i]
email = list_email[i]
#Define the employee
#object and store
#it in the dictionary.
employee_dict[id_num] = Employee(name, id_num, salary, email)
#Return the
#resultant dictionary.
return employee_dict
Answer:
Explanation:
import java.util.Scanner;
public class KboatTriangleAngle
{
public static void main(String args[]) {
Scanner in = new Scanner(System.in);
System.out.print("Enter first angle: ");
int a1 = in.nextInt();
System.out.print("Enter second angle: ");
int a2 = in.nextInt();
System.out.print("Enter third angle: ");
int a3 = in.nextInt();
int angleSum = a1 + a2 + a3;
if (angleSum == 180 && a1 > 0 && a2 > 0 && a3 > 0) {
if (a1 < 90 && a2 < 90 && a3 < 90) {
System.out.println("Acute-angled Triangle");
}
else if (a1 == 90 || a2 == 90 || a3 == 90) {
System.out.println("Right-angled Triangle");
}
else {
System.out.println("Obtuse-angled Triangle");
}
}
else {
System.out.println("Triangle not possible");
}
}
}
OUTPUT:
