What statistical test should you use if you have four categorical independent variables with 2 or more levels and 2 interval ratio-dependent variables?

In a sumif conditional function, what should be the order of terms in the parentheses?

The u.s. stock market has returned an average of about 9% per year since 1900. this return works out to a real return (i.e., adjusted for inflation) of approximately 6% per year. if you invest $100,000 and you earn 6% a year on it, how much real purchasing power will you have in 30 years?

Acompany manufactures x units of product a and y units of product b, on two machines, i and ii. it has been determined that the company will realize a profit of $3 on each unit of product a and $4 on each unit of product b. to manufacture a unit of product a requires 7 min on machine i and 5 min on machine ii. to manufacture a unit of product b requires 8 min on mchine i and 5 min on machine ii. there are 175 min available on machine i and 125 min available on machine ii in each work shift. how many units of a product should be produced in each shift to maximize the company's profit p?