You are the digital marketing director for High West Fashions, a regional clothing company that specializes in custom t-shirts. Your company has decided to launch an online advertising campaign that gives customers the ability to purchase heavily discounted products. You have the task of determining the optimal amount of advertising to purchase in order to maximize profit and most effectively utilize resources. Start   Excel. Download and open the file named . Grader has automatically added   your last name to the beginning of the filename. On the Direct Marketing   worksheet, create appropriate range names for (cell B8), (cell B9), (cell B10), (B11), and (cell B12). Edit the existing name range   Design_Fee to to reflect the current year. Use the newly created range   names to create a formula to calculate Gross Profit (cell B12) and Net Profit   (cell B13). Create a new worksheet named , paste the newly created range   name information in cell A1, and resize the columns as needed for proper   display. Mac users, use the Insert menu to insert a new worksheet and paste the range   names. On the Direct Marketing   worksheet, use Goal Seek to determine the optimal click rate in order to earn   a net profit. Starting in cell E4. Complete   the series of substitution values ranging from to 6.5% at increments of .50% vertically down   column E. Enter references to the Gross   Profit and Net Profit in the correct location for a one-variable data table. Complete the one-variable data   table, and then format the results with Accounting Number Format with two   decimal places. Apply custom number formats to   display in cell F3 and in cell G3. Copy the response rate   substitution values from the one-variable data table, and then paste the   values starting in cell I4. Type in cell J3. Complete the series of substitution   values from 10000 to 40000 at 5000 increments. Enter the reference to net   profit formula in the correct location for a two-variable data table. Complete the two-variable data   table and format the results with Accounting Number Format with two decimal   places. Apply a custom number format to   make the formula reference appear as . Make the Direct Marketing 2   worksheet active. Create a scenario named , using Number of Ads and Click   Rate. Enter these values for the scenario: , and . Create a second scenario named , using the same changing cells.   Enter these values for the scenario: , and . Create a third scenario named , using the same changing cells.   Enter these values for the scenario: , and . Generate a scenario summary   report using Gross Profit and Net Income. Return to the Direct Marketing 2   worksheet. Load the Solver add-in if it is not already loaded. Launch Solver   and set the objective to calculate a net profit of . Use Number of Ads and Click Rate   ( ) as changing variable cells. Set a constraint to ensure   Number of Ads purchased is less than or equal to . Set a constraint to ensure Click   Rate is less than or equal to . (Mac users should enter the value in decimal form. Example ) Solve the problem. Generate the   Answer Report. Create a footer on all   worksheets 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 .   Exit Excel. Submit the file as directed.

As a prerequisite to this assignment, view “The ‘Jesus’ Film” at Complete the “Jesus Film Worksheet and Journal #2.” GCU style is not required, but solid academic writing is expected. 1) In order to complete this assignment, access and view for free at website. 2) Not only is it paramount for the Christian to understand who Jesus Christ is in the Bible, but also to know the significance of His life and ministry. In order to more fully understand how the life and teachings of Jesus Christ impact the Christian, watch the film then complete the worksheet. 3) Answer the following questions using this document as a template. 4) GCU style is not required, but solid academic writing is expected. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. Use the space below to compose a journal of 250-500 words on the historical and personal attributes of Jesus by answering the following: APA is not required for this assignment but solid academic writing is expected.

Researchers in organizational psychology apply multiple theories to explain work motivation. To better understand how these theoretical models have evolved requires tracing work motivation theory from its beginnings to the present day. Understanding the influences and interconnectedness of theoretical frameworks informs motivation and may reveal future directions and trends in work motivation research. A review of the historical trajectory of work motivation theory not only informs your responses to clients grappling with motivational problems affecting their employees, but may also equip you with relevant knowledge and insight to handle challenges affecting tomorrow’s workforce as well. For this Discussion, you examine the changes in the evolution of work motivation theory and consider how you might apply work motivation theory to your present or future work settings. With these thoughts in mind: a brief explanation of two significant changes that have occurred in the evolution of work motivation theory. Then explain why these are significant. Finally, explain how you might apply work motivation theory to your current or future work setting. Be specific and support your response with references to the Learning Resources and current literature.

In an attempt to increase business on Monday nights, a restaurant offers a free dessert with every dinner order.  Before the offer, the mean number of dinner customers on Monday was 150.  The numbers of diners on a random sample of 12 days while the offer was in effect are selected.  Can you conclude that the mean number of diners increased while the free dessert offer was in effect? What is (are) the parameter(s) of interest? Construct a normal probability plot and a boxplot to visualize the distribution of your sample data.  Copy and paste these graphs into your assignment.  Below the graphs, answer the following questions. Are there any major deviations from normality? Are there any outliers present? Is it appropriate to conduct statistical inference procedures, why or why not? If the answer to part iii is no, do not complete the rest of #3. At the 0.05 significance level, can you conclude that the mean number of diners increased from 150 while the free dessert offer was in effect? State the null and alternative hypotheses. State the significance level for this problem. Calculate the test statistic. Calculate the P-value and include the probability notation statement. State whether you reject or do not reject the null hypothesis. State your conclusion in context of the problem (i.e. interpret your results). Construct a 99% confidence interval for the above data.  Interpret the confidence interval. According to a report of the Nielsen Company, 65% of Internet searches used Google as the search engine.  Assume that a sample of 13 searches is studied.  Let the random variable  be the number of searches where Google was used. What is the name of the probability distribution of X?  Write out the setting (i.e. write out the four requirements of a particular setting that you learned in class). Produce a table that lists the possible values of the random variable and the corresponding probabilities of each value’s occurrence. What is the mean of this distribution?  Show work using the formula. What is the standard deviation of this distribution?  Show work using the formula. Calculate the probability that of the 13 searches analyzed, at least 8 of those searches used Google.  Display a Minitab Graph with the correct portion shaded as the answer to this question.  Then, verify your answer with using the table you displayed in part (b). According to the U.S. Department of Agriculture, 58.8% of males between 20 and 39 years old consume the minimum daily requirement of calcium.  After an aggressive “Got milk” advertising campaign, the USDA conducted a survey of 55 randomly selected males between the ages of 20 and 39 and finds that 36 of them consume the recommended daily allowance of calcium. If we conduct statistical inference above, what is (are) the parameter(s) of interest? Construct a 96% confidence interval for the above data.  Interpret the confidence interval as we learned in class.  Show your work using the formulas. Construct a 96% confidence interval for the above data using the Plus Four Estimate.  Interpret the confidence interval as we learned in class.  Show your work using the formulas. At the 0.05 significance level, is there evidence to conclude that the percentage of males between the ages of 20 and 39 who consume the recommended daily allowance of calcium has increased? State the null and alternative hypotheses. State the significance level for this problem. Check the conditions that allow you to use the test statistic, and, if appropriate, calculate the test statistic. Calculate the P-value and include the probability notation statement. State whether you reject or do not reject the null hypothesis. State your conclusion in context of the problem (i.e. interpret your results). Purchase the answer to view it