Project Instructions: Investigate the theory that Google's local search rankings are influenced by a business's operational status at the time of the search. This study focuses exclusively on "local rankings" in Google Maps listings. Create a PowerPoint presentation highlighting your findings from the research below. The PowerPoint should include: . . . . An overview of the project The answers to all the questions below Insert the excel spreadsheet: https://files.pillardigital.io/external/sheet/4a633e3d158427b82afdbdb76f3f90dd3bbde0493f9bf868f24e52c690269145 (you can use Google sheets if you prefer, just copy and paste the headings) Graphical representations mentioned below Concluding statements Questions to Answer: 1. Is there a correlation between local Google search rankings and whether a business is open at the time of the search? 2. How does the ranking of a business change during its operating and non-operating hours? 3. Is there a variation in this potential ranking change across different business categories (e.g., roofer, electrician, HVAC contractor)? 4. Does the size or population density of a city influence the extent of any observed correlation? 5. Is there a correlation between the number of reviews and the ranking of the business? a. Is there a correlation between the average star rating and the ranking of the business? Task Outline: 1. City Selection: 2. Search Procedure: . Choose 5 suburban cities in the United States (excluding New York state) with a population of at least 20,000. Perform Google Maps searches on a computer at two different times and on two different days: • At 12:00 PM for businesses during likely operating hours. • At 9:00 PM or 7:00 AM for businesses during likely non- operating hours. Searches to be conducted for the following business categories: 0 . Roofer (e.g., "roofer Scottsdale AZ") . Electrician (e.g., "electrician Scottsdale AZ") HVAC Contractor (e.g., "HVAC contractor Scottsdale AZ") 3. Data Collection: Record data in the provided spreadsheet with columns for: Date & Time of Search . City and State Population of city Business Type (Roofer, Electrician, HVAC) Business Name and Ranking Position . Operational Status (Open/Closed) at the Time of Search . Whether business is open 24 hours Number of Reviews and Average Review Score (for additional context) . . . . 4. Data Analysis: 。 Compare the rankings of businesses that are open vs. businesses that are closed on the same day • Compare the rankings across two different days to see if there are potentially daily fluctuations Analyze variations across different cities and business types. Examine any correlations between city size/population density and ranking changes. Questions to Answer: 1. Is there a correlation between local Google search rankings and whether a business is open at the time of the search? 2 How does the ranking of a business change during its operating and non-operating hours? 3. Is there a variation in this potential ranking change across different business categories (e.g., roofer, electrician, HVAC contractor)? 4. Does the size or population density of a city influence the extent of any observed correlation? 5. Is there a correlation between the number of reviews and the ranking of the business? a. Is there a correlation between the average star rating and the ranking of the business? Task Outline: 1. City Selection: . Choose 5 suburban cities in the United States (excluding New York state) with a population of at least 20,000. 2 Search Procedure: • Perform Google Maps searches on a computer at two different times and on two different days: . . At 12:00 PM for businesses during likely operating hours. . At 9:00 PM or 7:00 AM for businesses during likely non- operating hours. Searches to be conducted for the following business categories: . . Roofer (e.g., "roofer Scottsdale AZ") . Electrician (e.g., "electrician Scottsdale AZ") 3. Data Collection: Record data in the provided spreadsheet with columns for: . Date & Time of Search HVAC Contractor (e.g., "HVAC contractor Scottsdale AZ") . City and State . . . Population of city Business Type (Roofer, Electrician, HVAC) Business Name and Ranking Position Operational Status (Open/Closed) at the Time of Search . Whether business is open 24 hours • Number of Reviews and Average Review Score (for additional context) 4. Data Analysis: . Compare the rankings of businesses that are open vs. businesses that are closed on the same day • Compare the rankings across two different days to see if there are potentially daily fluctuations • Analyze variations across different cities and business types. • Examine any correlations between city size/population density and ranking changes. 5. Graphical Representation: Create graphs to illustrate: Ranking shifts of businesses between operating and non- operating hours. Comparison of ranking shifts across different business types. . Correlation (if any) between city size/population and ranking shifts. Additional Considerations: Ensure consistency in the search methodology (e.g., using the same device (computer), internet browser, and Google account settings). . Consider the potential impact of day-to-day ranking fluctuations unrelated to operational hours. Document any anomalies or patterns observed during data collection.